May 29, 2002 at 7:49 am
I intially left my sa password blank when I installed sql server 2000 (I know bad idea). I have created many jobs in a short time. I changed my sa password the other day and now all my jobs are failing "login failed for sa password." What am I missing? Do I need to change any configurations when I go from a blank sa to a new password?
May 29, 2002 at 7:55 am
Are they DTS packages or just plain TSQL jobs?
Andy
May 29, 2002 at 8:00 am
Also, how is you SQL Server Agent configured to connect to SQL Server? Right click Agent in EM and choose properties. Then on the connection tab you will see "SQL Server connection".
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 29, 2002 at 8:07 am
quote:
Are they DTS packages or just plain TSQL jobs?Andy
http://www.sqlservercentral.com/columnists/awarren/
They are DTS Packages.
May 29, 2002 at 8:30 am
Try manually specifying the password/login on the dtsrun command line.
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply