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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server Replication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-10-24 : 15:17:20
Travis Wright writes "I am going through and changing all my SA passwords on my SQL server machines. I have a seperate machine for my Distributor and Publisher. My Snapshot fails as soon as a Change the SA password on the Publisher. The error I get is 'login failed for SA'. I have looked, but I can't find where the agent stores the SA password so the agent can run correctly."
   

- Advertisement -