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.
| Author |
Topic |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2006-05-31 : 07:09:14
|
| Hi Gurus,I have mapped a network drive that F:But when I try to access it using XP_CMDSHELL it doesn't work. It give me error"The system cannot find the path specified." I am running this query using SA and have full rights.When execute command "DIR F:", it works but not from QA.It works in my development server but not on staging. On both the server, SQL server is running under local account. I also tried using domain Id but no luck.Thanks for your help in advance.RegardsSachin Don't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-05-31 : 07:22:34
|
| You wouldn't be able to do that, because the drive is mapped under your user's context, not the local system account's. You'd need to (preferably to anything else) use the UNC path to the directory instead. Also, if it's a remote drive, you'd need to be running SQL under a domain account that has permission to list the contents of the remote path.-------Moo. :) |
 |
|
|
|
|
|
problem xp_cmdshell