RE: Jobs stoped to work after changing SA password.

RE: Jobs stoped to work after changing SA password.

 

  

Thank you very much Uday.

You just saved my life (well... almost).
Jobs are now working, but the replication process (to another database on the same server) is now stopped.
Distribution agent gives a message:
The process could not connect to Subscriber 'MyServerName'.

It looks like I have to change the password somewhere else, but I can not find the place.

I would be glad to hear any idea.

Yuriy.

________________________________

From: Uday Shivamurthy [mailto:mssqldba-ezmlmshield-x16961163.[Email address protected]
Sent: Mon 03/28/05 9:21 PM
To: LazyDBA Discussion
Subject: RE: Jobs stoped to work after changing SA password.



Enterprise manager
Go to management
Select Sql Agent
Right click -> properties
Go to tab "connection"
If you've set up sql-agent service to authenticate with sql-server using
sql-server authentication; fix the pwd and you're good to go.

Regards,
Uday
.....................................
Direct: +61-2-98059739
Mobile: +61-401 705907
Email: [Email address protected]

-----Original Message-----
From: Gregorev Yuriy
[mailto:mssqldba-ezmlmshield-x29874604.[Email address protected]
Sent: Tuesday, 29 March 2005 5:28 AM
To: LazyDBA Discussion
Subject: Jobs stoped to work after changing SA password.

I have a set of scheduled jobs on my MS SQL server 2000 and they were
working fine until I changed SA password (using sa_password procedure).

If I change the password back they start to work normally.
If I change the password and then create a new job it does not work either.
I was connected as a trusted user when I created the jobs.

What else should be changed along with the SA password?

Windows 2000 pack 4, MS SQL 2000 pack 3.

Thanks you in advance,

Yuriy.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




MS Sql Server LazyDBA home page