Author: SQL ProgrammerSQL Programmer Date: Sep 18, 2008 17:32
Hello:
We have a DTS package in SQL 2000 with service pack 4. We, also, have a bat
file that users double-click on in order to run it.
One user can run it, another cannot. The log file for the bat file says
"Login failed for user 'sa'". My only guess is that it is a network
credentials issue. (The users, also, have a SQL user ID through an
accounting application that they use.)
Are there any special network credentials that can be "added" to a SQL user
ID in order to beef up its credentials, so that it will not get this "sa"
issue and can run a DTS package through a bat file?
Thanks!
SQL Programmer (it's just a name)
|