| Author |
Backing up a database to a remote shared folder
|
|
| Wingman 2005-12-28, 11:23 am |
| We are using SQL 2K with sp4 on W2K servers but they are in windows workgroup
not domain. The SQL service is started by the local system account. I am
having a hard time trying to back up a database to a remote shared folder
located in another W2K server in the same windows workgroup. I believe it is
an authentication/permission issue. I am aware that SQL server looks at
network shared folder differently than the way Windows see but don't know
how to get around it under the workgroup setup. If it is under domain setup,
I have no problem.
Any help on this is very much appreciated.
Wingman
| |
| Andrew J. Kelly 2005-12-28, 11:23 am |
| The account that SQL Server runs under must have permissions to that share.
Make sure you use UNC for the path and not a mapped drive.
--
Andrew J. Kelly SQL MVP
"Wingman" <Wingman@discussions.microsoft.com> wrote in message
news:45312278-0845-433D-8F7D- 2139BD2B0523@microso
ft.com...
> We are using SQL 2K with sp4 on W2K servers but they are in windows
> workgroup
> not domain. The SQL service is started by the local system account. I am
> having a hard time trying to back up a database to a remote shared folder
> located in another W2K server in the same windows workgroup. I believe it
> is
> an authentication/permission issue. I am aware that SQL server looks at
> network shared folder differently than the way Windows see but don't know
> how to get around it under the workgroup setup. If it is under domain
> setup,
> I have no problem.
>
> Any help on this is very much appreciated.
>
> Wingman
| |
| Wingman 2005-12-28, 1:23 pm |
| Yep, I know about the UNC part but how do I assign the local account that run
SQL server to that share under the WorkGroup envirnoment. I am not very
familar with the Windows Workgroup setup. From the computer that I have the
shared folder, I can't see any user account from other computers. I believe
it is because of the Workgroup setup but then again it may be just my
inexperience in this area. Please advise.
Wingman
"Andrew J. Kelly" wrote:
> The account that SQL Server runs under must have permissions to that share.
> Make sure you use UNC for the path and not a mapped drive.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Wingman" <Wingman@discussions.microsoft.com> wrote in message
> news:45312278-0845-433D-8F7D- 2139BD2B0523@microso
ft.com...
>
>
>
| |
| Tibor Karaszi 2005-12-28, 8:23 pm |
| You'd have to create an account with same name and password as the service account on that other
machine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"Wingman" <Wingman@discussions.microsoft.com> wrote in message
news:6075EA91-4D10-4E03-A3D1- 3BB693F750D6@microso
ft.com...[color=darkred]
> Yep, I know about the UNC part but how do I assign the local account that run
> SQL server to that share under the WorkGroup envirnoment. I am not very
> familar with the Windows Workgroup setup. From the computer that I have the
> shared folder, I can't see any user account from other computers. I believe
> it is because of the Workgroup setup but then again it may be just my
> inexperience in this area. Please advise.
>
> Wingman
>
> "Andrew J. Kelly" wrote:
>
| |
| Andrew J. Kelly 2005-12-28, 8:23 pm |
| I am not sure if you can use the local service account or not in a workgroup
for this. You could set the permissions on the share to allow everyone to
read and write to it but that would obviously allow anyone with access to
that workgroup to access that share. Maybe someone with more experience in
WorkGroups can pipe in.
--
Andrew J. Kelly SQL MVP
"Wingman" <Wingman@discussions.microsoft.com> wrote in message
news:6075EA91-4D10-4E03-A3D1- 3BB693F750D6@microso
ft.com...[color=darkred]
> Yep, I know about the UNC part but how do I assign the local account that
> run
> SQL server to that share under the WorkGroup envirnoment. I am not very
> familar with the Windows Workgroup setup. From the computer that I have
> the
> shared folder, I can't see any user account from other computers. I
> believe
> it is because of the Workgroup setup but then again it may be just my
> inexperience in this area. Please advise.
>
> Wingman
>
> "Andrew J. Kelly" wrote:
>
| |
|
|
|
|