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....
- Edited by Anitha.B Thursday, September 19, 2013 2:25 PM
Just as Brandon post above, you can run SQL profiler to trace the failed transaction. You can also use sp_helpsubscriptionerrors to display the of list invalid transactions.
The following thread is about the similar issue,please refer to:
TechNet Community Support