Replication Error - SQL Server Forums

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

Replication (2008)

Replication Error

Author

Topic

mbehring
Starting Member

4 Posts

Posted - 2012-01-17 : 09:36:41

Hi list,

I have configured a Transactional Replication for one of our Databases. The replication configuration process occurred without any errors. The problem is when I run the replication, the initial snapshot...I get the error below (got the error on the log file viewer) from "SQL Server Agent -> Jobs" at Management Studio:

2012-01-17 14:40:48.173 Copyright (c) 2008 Microsoft Corporation
2012-01-17 14:40:48.173 Microsoft SQL Server Replication Agent: logread
2012-01-17 14:40:48.173
2012-01-17 14:40:48.173 The timestamps prepended to the output lines are expressed in terms of UTC time.
2012-01-17 14:40:48.173 User-specified agent parameter values:
-Publisher 03SQL0
-PublisherDB PROTHEUS10_TESTE
-Distributor 03sql0
-DistributorSecurityMode 1
-Continuous
-XJOBID 0x4D09D7D16381224695A1764B7323DD8D
-XJOBNAME 03SQL0-PROTHEUS10_TESTE-3
-XSTEPID 2
-XSUBSYSTEM LogReader
-XSERVER 03SQL0
-XCMDLINE 0
-XCancelEventHandle 00000B20
-XParentProcessHandle 00000B58
2012-01-17 14:40:48.318 Status: 0, code: 20015, text: 'Login failed for user 'MSIGA'.'.
2012-01-17 14:40:48.318 Login failed for user 'MSIGA'.

This MSIGA user has all permissions possible inside both SQL Server machines, including 'sa'.

What could be wrong?

Thanks
Mario

sandesh.ravi
Posting Yak Master

110 Posts

Posted - 2012-01-17 : 12:53:35

Have you changed the MSIGA password?

This would occur due to wrong password.

Thanks,
Sandesh

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources