Groups | Blog | Home
all groups > sql server replication > may 2006 >

sql server replication : SQL2K - Create publication wizard error



PierreJulien
5/19/2006 7:18:02 AM
At the end of the configuration of the wizard for a transactional replication
between two SQL 2000 SP3+, i get the following error :

Error 0: This Server has been disconnected. You must reconnect to perform
this operation

I didnt find any clues in tte sql log or the events log. Neither in
searching the KB.
Anyone has experienced this error or knows where it may come ?
Hilary Cotter
5/19/2006 10:29:12 PM
No, try to add it manually

sp_replicationdboption 'pubs','publish','true'
GO
sp_addpublication 'test',@status='active'
go
sp_addpublication_snapshot 'test'
GO
sp_addarticle'test','authors','authors'

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

AddThis Social Bookmark Button