Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 xp_cmdshell problem

Author  Topic 

DeveloperIQ
Yak Posting Veteran

71 Posts

Posted - 2008-12-10 : 18:23:41
I have a job that writes out a texfile to a location on the network. The SQLAgent service is set to run under a domain admin account. And this domain user has the correct rights to write to this network location. I am able to login as this user on a box and do things within the network folder. But the job failes each time. If I do xp_cmdshell to view the directory contents, I get an Access Denied error. Can anyone suggest what could be wrong?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-10 : 18:45:38
Does the SQL Server service run under the same account too?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

DeveloperIQ
Yak Posting Veteran

71 Posts

Posted - 2008-12-10 : 19:09:11
Yes it does!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-10 : 19:44:57
We are also experiencing this issue and have an open case with Microsoft on it. Unfortunately, they have been unable to resolve our issue. Our issue only happens once a month though and a restart of the SQL Server service clears the "Access is denied" error message. Microsoft is very perplexed by it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -