May 1, 2012 at 7:30 am
I am trying to setup transactional replication from server A to server B.
Server A is created by using Image of similar machine but with different name. I change name with sp_dropserver and sp_addserver. when I do select @@server, I get the right name. I checked in sysservers table and sever ID is set to zero. sqlserver is installed with domain account.
When I setup replication I get error 'distributor is not configured right'
distributor and publisher is on the same server. can some one help ?
May 4, 2012 at 4:38 am
have you setup the distribution fresh here or its a part of image ? if its part of image can you try to create it fresh
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2012 at 6:23 am
I found the problem. The database files I have used to create DB had some information about replication on different machine. I recreate DB and now it is working fine.
Thanks...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply