New Subcription Error
-
Dienstag, 12. Februar 2013 17:52
Hi,
I have two servers, I have installed Microsoft SQL Server 2008 R2(Dev) on both servers with service pack 2. Both servers have connectivity with each other. I have tested connectivity with PING command and i am also able to access server 2 sql server instance on server 1 and viceversa.
Now i am trying to configure SQL Server transactional replication with updatable subcription on both server.
I have created server 1 as publisher/distributor successfully but when i am trying make subscriber on Server 2, i am getting following error :-
"The subscription already exist".
Note:- i don't have found any subscription under local subcription in replication node.
Thank you.
- Bearbeitet Deepak153096 Dienstag, 12. Februar 2013 18:21
Alle Antworten
-
Dienstag, 12. Februar 2013 18:17Moderator
What happens when you issue a call to sp_MSenumsubscriptions 'both' in your subscription server in your subscription database?
If nothing is returned and there are no active subscrptions there issue a call to
sp_removedbreplication 'SubscriberDatabaseName','both'
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
-
Dienstag, 12. Februar 2013 18:53
hi,
Thanks for reply.
i have run sp_MSenumsubscriptions 'both' at subscription server and not get any result after that i have also run sp_removedbreplication 'SubscriberDatabaseName','both' . it excecuted successfully.
but i am getting same error when i am trying to make subscription at subscription server.
-
Dienstag, 12. Februar 2013 21:31Moderator
if you issue a call to
sp_helpsubscription 'PublicationName', 'ALL','SubscriberName'
On the publisher - What is returned.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
-
Mittwoch, 13. Februar 2013 04:42
Ok.
when i issue a call to sp_helpsubscription 'PublicationName', 'ALL','SubscriberName' then i am getting following message."The Publication does not exist".
-
Mittwoch, 13. Februar 2013 16:05Moderator
But it looks like that publication does exist - correct?
I am wondering if the issue is with the updatable subscriber. Does a normal subscription (transactional without updateable subscribers) work?
Please also post this on the publisher.
select @@ServerName
GO
exec master.dbo.xp_cmdshell 'hostname'
GO
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
.png)
.png)
