November 15, 2007 at 2:57 am
Hey all,
We changed the SA password recently on one of our servers.
It now seems that scheduled DTS tasks wont fire saying "login failed for user 'SA' (the DTS package fires manually fine).
Now it all packages failed yesterday saying the SA password is incorrect. I have changed in in the SQL server agent, the SQL password, also i have checked that the DTS packages uses a different account.
Now the weird thing is - some of the packages now worked today, but some of them still fail on SA.
Where is the residual SA account being used? Where can i change it? What is going on? HELP!
Dan
November 15, 2007 at 4:46 am
Hi,
Check this link may be it help you
http://forums.databasejournal.com/archive/index.php/t-14790.html
Regards,
Ahmed
November 15, 2007 at 5:01 am
But i have nothing in the DTS package referencing SA (it runs ok when you trigger it manually) - and i have actually scripted the scheduled task, and searched for SA - again nothing!!
D
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply