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 |
|
BenSwitzer
Yak Posting Veteran
72 Posts |
 Posted - 2005-02-02 : 14:47:50
|
| I have created a DTS and am attempting to execute it in a stored procedure. When I do I get this error.DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: Error opening datafile: Logon failure: unknown user name or bad password. I have scheduled the dts as a job and it works fine that way. Why am I getting a login error when going through a sp? |
|
|
rishimainidba
Starting Member
30 Posts |
Posted - 2005-02-02 : 22:16:12
|
| In your case Job is run under the security credentials of ur SQL Server Agent Start up account and sp is run under the credentials of your domain account by which u have logged in.So just login by the correct user which has access to the specified resources on network which are mentioned in ur DTS Package.Just do it and let me know whether u got it working or not?Waiting 4 ur reply.RegardsRishi |
 |
|
|
BenSwitzer
Yak Posting Veteran
72 Posts |
Posted - 2005-02-03 : 08:24:02
|
| I am logged in as the same user as the SQL Server Agent startup account and got a different error. Something like access permission to datafile. So I changed Start Up Service account to the same account. Now it is working like a charm! Thanks for your help. |
|
|
|
|
|
|
DTS Execution Login error