June 1, 2007 at 6:25 am
Hi, my local sql server (sql express) starts with NT "AUTHORITY\Network Service" account and when I need to access to remote folders (located on anothers servers) I can't get it works, it says: "Access is denied."
I use a query with a user validated on a domain and this user has full permissions to folders.
In the remote folders I set fully perrmissions to everyone but nothing change.
If I restart the "Sql Server" service (not agent service) with a domain user, xp_cmdshell works.
June 1, 2007 at 6:42 am
When you use local account yu can't access resources in network. Better change the account running your sql server and agent to a domain/workgroup account and grant the necessary permissions and try the same it should work out very fine.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 1, 2007 at 6:49 am
thanks dude.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply