Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Can not able to create publication

Author  Topic 

malikjaved
Starting Member

21 Posts

Posted - 2008-02-28 : 04:16:19


Hi guys.



i had configured a merge replication betwen 2 server and i was running fine. but due to network problems my network admin has changed the ip address and name of the publisher, distributor and subscriber.



what i did. i just drop the publication and now i m trying to create a new one. but i cannt' able to create. i dont' know y.. this is the error i m facing..



Msg 208, Level 16, State 1, Procedure sp_addmergepublication, Line 239

Invalid object name 'dbo.sysmergepublications'.

Msg 21040, Level 11, State 1, Procedure sp_MSaddmergepub_snapshot, Line 65

Publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 208, Level 16, State 1, Procedure sp_changemergepublication, Line 205

Invalid object name 'dbo.sysmergepublications'.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-02-28 : 10:10:03
Did you disable Publishers and distributor before you start new publication?
Go to Top of Page
   

- Advertisement -