December 30, 2009 at 11:12 pm
Hi,
I am trying to configure Peer to peer replication.
But at middle it thrwoing an below error.
(all replication jobs are going fine. dont know y this error is coming)
---------------------------------------------------------------------
Building the Peer
-To-Peer Topology...
-
Creating publication on 'SERVER1.azSOME'... (Success)
-
Creating subscription for 'SERVER2.azSOME' on 'SERVER1.azSOME'... (Error)
Messages
* SQL Server could not create a subscription for Subscriber 'SERVER2'. (Configure Peer-To-Peer Topology Wizard)
------------------------------
ADDITIONAL INFORMATION
An exception occurred
while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
-----------------------------
Could not complete setting up the no-sync subscription at the Distributor while the distribution cleanup agent is running. The operation has a greater chance of success if the distribution cleanup agent is temporarily disabled.
The subscription could not be found.
Changed database context to 'azSOME'.
Job 'SERVER1-azSOME-azSOME_P2P-SERVER2-75' started successfully.
Warning: The distribution agent job has been implicitly created and will run under the SQL Server Agent Service Account. (Microsoft SQL Server, Error: 21398)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2734&EvtSrc=MSSQLServer&EvtID=21398&LinkId=20476
-
Creating subscription for 'SERVER1.azSOME' on 'SERVER2.azSOME'... (Success)
---------------------------------------------------------------------
Please help me to resolve this error.
Thanks
December 20, 2010 at 11:05 am
To solve this problem I only restarted the SQL Server
Bruno Santos
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply