Can not create Backup device on a shared network ???

[sarah77]

Hi,
Can you explain why i'm not be able to create a backup device on a shared network drive ?.

Please consider that I can browse the network through "My network" on desktop and I can see all shared network drives.

The Problem is still even if I use the UNC such as "\\server\shareddrive".

Really i'm confused why I can see all shared network drives through a windows2000 network icon on desktop but within SQL2000 i'm not be able to access it when I want to create a backup device ???

Any comment wil be so much appreciated.

 

[sguslan]

Hi ,,,


Make sure that TCP/IP setup is correct on both machines, including correct DNS/DHCP parameters...

If you can provide the exact error messages, may be somewone can help you more...

Good luck..

Salim

 

[tlbroadbent]

SQL 2000 runs as a SERVICE in its own context with its own logon account. It does not run under the Windows logon. The implications of this are...

1) SQL Server does not see the mapped drives you see from Windows Explorer when you login to Windows NT on the Server.

2) The SQL logon account is often setup as a LOCAL Administrator on the Server. Therefore SQL has no permissions in the domain. That means it cannot see or update shares on other servers.

3) If the SQL account is setup as a domain account, it often doesn't have permissions on other servers. A network administrator must specifically grant permissions to the SQL account.

Let me know if you have have questions or need further clarification. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.