Very Computer

I recall reading in Neil Pike's FAQ that SQL server as default runs
under some local name that does not have permission to access shares.
Does this apply even to "local" shared folders?

Also, what is the exact NT name under which SQL server runs, and if I
add permissions for this username to the shared folder, should
everything work OK?

Thanks in advance
Sebastian

Hope this helps.

-----------------------
SQL FAQ links (courtesy  Neil Pike):

 http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
 (faqxxx.zip in lib 7)
 or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq
-----------------------

Quote:> Hello,
> I new to SQL server, and cannot figure how to resolve the following:
> SQL-DMO (ODBC error 42000) Device error or device offline. Cannot open
> Backup device 'D:\SQL Backups\pubs.bak'
> I am using enterprise manager SQL2000 on a Windows NT 4.0 workstation,
> and am attempting to backup a database using SQL*Server 2000 on a
> remote Win 2000 server.
> "D:\SQL Backups" does exist on the remote server, and the lan
> administrator created a share for it (named  \\servername\sqlbu ), so
> that I can copy the backups to my local development server.
> I think the problems lies because he removed all permissions to the
> shared backup folder, other than my \\domain\ntloginname and the
> domain administrators.

> I recall reading in Neil Pike's FAQ that SQL server as default runs
> under some local name that does not have permission to access shares.
> Does this apply even to "local" shared folders?

> Also, what is the exact NT name under which SQL server runs, and if I
> add permissions for this username to the shared folder, should
> everything work OK?

> Thanks in advance
> Sebastian

Quote:> Hello,
> I new to SQL server, and cannot figure how to resolve the following:
> SQL-DMO (ODBC error 42000) Device error or device offline. Cannot open
> Backup device 'D:\SQL Backups\pubs.bak'
> I am using enterprise manager SQL2000 on a Windows NT 4.0 workstation,
> and am attempting to backup a database using SQL*Server 2000 on a
> remote Win 2000 server.
> "D:\SQL Backups" does exist on the remote server, and the lan
> administrator created a share for it (named  \\servername\sqlbu ), so
> that I can copy the backups to my local development server.
> I think the problems lies because he removed all permissions to the
> shared backup folder, other than my \\domain\ntloginname and the
> domain administrators.

> I recall reading in Neil Pike's FAQ that SQL server as default runs
> under some local name that does not have permission to access shares.
> Does this apply even to "local" shared folders?

> Also, what is the exact NT name under which SQL server runs, and if I
> add permissions for this username to the shared folder, should
> everything work OK?

Quote:> Thanks in advance
> Sebastian