February 24, 2005 at 1:28 pm
hi guys
I have a dts package which pulls database backups from 2 servers
I am mapped to 2 other servers via mapped drives and different user names to pull these backups
logged in as admin i can run the DTS package fine, but when I try and run it from command line, I get files not found. It even does this with SQL agent set to run as admin
any ideas?
thanks
Ross
February 25, 2005 at 1:27 am
SQL Server runs under it's own user, so mapped drives under your username may not be accessable from the command line.
The easy solution is to use UNC filenames.
eg \\ServerName\Sharename\Directory\filename
February 25, 2005 at 10:19 am
I had the same problem using mapped drives and for some reason wasn't working even if the SQL service was started with a proper account.
Solution: use network path for file name
the win account under wich the SQL Server is started must have proper rigths for this
Vasc
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply