Changing 'sa' password breaks replication

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 2005 Forums

Replication (2005)

Changing 'sa' password breaks replication

Author

Topic

tclaw
Starting Member

5 Posts

Posted - 2008-04-17 : 08:52:31

We are currently using continuous transactional replication from an OLTP type database to a Reporting database. We recently changed the 'sa' password for the first time since replication was introduced and now the Replication Log Reader job fails to start.

This is the error from the Job Log:


Message
2008-04-14 15:18:24.894 Copyright (c) 2005 Microsoft Corporation
2008-04-14 15:18:24.894 Microsoft SQL Server Replication Agent: logread
2008-04-14 15:18:24.894 
2008-04-14 15:18:24.894 The timestamps prepended to the output lines are expressed in terms of UTC time.
2008-04-14 15:18:24.894 User-specified agent parameter values:
			-Publisher OASV-SQL1
			-PublisherDB georgiaoas
			-Distributor OASV-SQL1
			-DistributorSecurityMode 1
			-Continuous
			-XJOBID 0xCE146F975BC43043AB1ECBF42F801C43
			-XJOBNAME OASV-SQL1-georgiaoas-1
			-XSTEPID 2
			-XSUBSYSTEM LogReader
			-XSERVER OASV-SQL1
			-XCMDLINE 0
			-XCancelEventHandle 00000730
			-XParentProcessHandle 0000075C
2008-04-14 15:18:25.034 Status: 0, code: 20015, text: 'Login failed for user 'sa'.'.
2008-04-14 15:18:25.034 Login failed for user 'sa'.

When we change the 'sa' password back to the previous value, we can start the Log Reader without issue.

We have tried restarting the SQL Server Agent process without success. We have not restarted the SQL Server process due to the server hosting production databases.

Any ideas?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-17 : 11:28:25

Did you configure with sa account for securities of replication?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources