Backing up a database to a remote shared folder

We are using SQL 2K with sp4 on W2K servers but they are in windows workgrou
p
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 i
s
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

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

Yep, I know about the UNC part but how do I assign the local account that ru
n
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... 
>
>
>

You'd have to create an account with same name and password as the service a
ccount 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...
> 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 t
he
> shared folder, I can't see any user account from other computers.  I belie
ve
> 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:
> 

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...
> 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:
> 

Yep, this does it.  Thanks!!!

"Tibor Karaszi" wrote:

> 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... 
>
>