October 2, 2009 at 12:15 pm
naveenreddy.84 (10/1/2009)
Its a local drive!!!
Heh... local to what? Your workstation or the server?
--Jeff Moden
Change is inevitable... Change for the better is not.
October 2, 2009 at 12:21 pm
Also - keep in mind that this may not be running under your credentials. Depending on circumstances or version, you may need to check that the following user accounts have access to the executable, from the context of the server:
- the SQL service account
- the SQL Server Agent service account
- the xp_cmdshell proxy user account
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
October 2, 2009 at 12:24 pm
Local to the server!!!
October 2, 2009 at 12:33 pm
Then like Matt Miller is saying, whatever login the server is using, it doesn't have privs to the file. Find out what login the server is using and see if it has the necessary privs.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply