none
Replication Error: Exception Type: Microsoft.SqlServer.Replication.ConnectionFailureException

    Question

  • Hi,

     I tried on building transactional replication connecting the systems within same domain 

     while creating the publisher and subscriber given the domain credentials as in the windows account.

    Snapshot Agent and Log Reader Agent are not throwing any error. But when checking on  Job history the following error is thrown

    [SQLSTATE 22001] (Error 8152).

    Detect nonlogged agent shutdown.,,Executed as user: NT SERVICE\SQLSERVERAGENT. String or binary data would be   truncated. [SQLSTATE 22001] (Error 8152).  The step failed.,00:00:00,16,8152,,,,0    

    The exception type is

    Exception Type: Microsoft.SqlServer.Replication.ConnectionFailureException

    Someone please help on this....

    Thanks,

    Anitha.B

    575706

    • Edited by Anitha.B Thursday, September 19, 2013 2:25 PM
    Thursday, September 19, 2013 2:23 PM

All replies