January 9, 2012 at 6:40 am
HI,
i have set up the p2p replication between tow machines and i have used my windows accout (mm\bkumar) which has sysadmin writes on both machines. but still i am getting blow issue while checking the error log
Error: 14151, Severity: 18, State: 1.
Replication-Replication Distribution Subsystem: agent INBKUMAR02\SQL2008R2-CVENT_DM70-Pub_Test_BK-INKMEHTANI02\SQL2008R-9 failed. The process could not connect to Subscriber 'INKMEHTANI02\SQL2008R2'.
Error: 18456, Severity: 14, State: 11.
Login failed for user 'MMM\INKMEHTANI02$'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 10.30.0.25]
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 9, 2012 at 6:45 am
Is the same account been used for configuring SQL Server & SQL Server Agent Services?
January 9, 2012 at 6:56 am
NO... we have different account setting on both servers.
Additionally , i have UAC enabled with second stop option (from top)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 9, 2012 at 7:01 am
Configuring SQL Server Agent with sufficient rights is very important in Replication. Please visit following articles for more.
Replication Agents Overview
http://msdn.microsoft.com/en-us/library/ms152501.aspx
Configuring SQL Server Agent
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply