July 26, 2002 at 4:15 pm
Greetings!
We've been having some problems that hopefully you'll be able to shed some light on. We're trying to access a mapped Novell drive from a sp_cmdshell call within a stored proc (SQL 2000, btw). Every time we try to access J:\ (the mapped Novell 5.1 drive), it gives the message "The system cannot find the file specified". This is true whether or not we're logged in as Administrator or any other user.
Apparently there's a problem seeing the Novell share. Does anyone know what's going on here? Is it a security/permissions issue? If so, which user account is actually running the sp_cmdshell from a stored proc in SQL? Do we need to create a Novell user for that account?
This is really problematic because we need to use the sproc to call dtsrun.exe to execute a package. The package pulls data from an Access DB on the Novell share. Everytime the package runs, it gives us a file not found error. It works fine if we run the same command on the server command prompt or if we execute the package in Enterprise Manager. We're stumped. Any help is appreciated! Thanks!
Brian Laws
July 26, 2002 at 5:26 pm
We see a lot of the same problems even in pure Win environment. XP_Cmdshell is running under whatever you're using for the agent account. If that account does have disk access (or file share, whatever), lots of stuff goes wrong.
Andy
July 29, 2002 at 11:39 am
Thanks for the response!
The problem is, though, that the user does have permissions to the fileshare; same login and password. We were able to perform the cmdshell task on a shared directory on a coworker's Win2k box. That was setup using windows network, not novell. So, it seems to us to be a Novell issue.
Puzzling...
quote:
We see a lot of the same problems even in pure Win environment. XP_Cmdshell is running under whatever you're using for the agent account. If that account does have disk access (or file share, whatever), lots of stuff goes wrong.Andy
http://www.sqlservercentral.com/columnists/awarren/
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply