locked
Relpication error RRS feed

  • Question

  • 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
    Tuesday, January 17, 2012 2:32 PM

All replies