Unanswered: MS SQL Server 2000 replication question
We are replicating a database from one of our production 2000 sql servers to a laptop. The database contains employee information and photos for the security department and they bring the laptop offsite each night.
They changed the sql server 'sa' password on the laptop and now replication is failing. The distribution agent is failing with the error "Login failed for user 'sa'"
I cannot figure out how to change how replication is getting authenticated on the laptop. Am I going to have to drop and recreate the puublication?? hoping someone can give me some guidance on this one..