Tuesday, March 27, 2012

Connection Problem

Hello there
I have two servers on diffrent computer
Both of them are registered together
One of them declared as a publisher and the otherone as subscripter
When i add the subscript it gave me an error of connecting between them and
the synchronize is not active
where the problem can be?
Normally when you get the subscription is not active it means that your
publication is not activated.
in your publication database do this
sp_changepublication 'publicationname','status','active'
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Oded Kovach" <roygoldh@.hotmail.com> wrote in message
news:O8FBVRMlEHA.712@.TK2MSFTNGP09.phx.gbl...
> Hello there
> I have two servers on diffrent computer
> Both of them are registered together
> One of them declared as a publisher and the otherone as subscripter
> When i add the subscript it gave me an error of connecting between them
and
> the synchronize is not active
> where the problem can be?
>

No comments:

Post a Comment