November 9, 2006 at 2:32 pm
Hi all,
One of our servers ran into trouble with replication. It only had 1 snapshot publication with 5 articles. The server was the distributor and publisher. Problem is, when the server was rebooted it came up with errors that the publication did not exist but all the agents were all there trying to work away.
We couldn't drop the publication and start again as it wasn't there so we disabled that server as publisher and distributor. Sure enough that got rid of all the errors so we tried to set it back up again. When we do, we get this at the "Configuring Distributor" step :
"SQL Server Enterprise Manager could not configure 'SrvName' as the Distributor for 'SrvName'.
Error 512: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, > >= or when the subquery is used as an expression.
Password changed."
What the? What's it finding twice (or more)? There is no distribution database. The only replication table I can find is one in master called "MSReplication_options" which has 2 entries:
optname value major_version minor_version revision install_failures
transactional 10000
merge 10000
Anyone any ideas?
Thanks,
Martin
November 9, 2006 at 2:35 pm
Sorry, we're running SQL Server 2000 SP4 on Win Srv 2003.
November 13, 2006 at 11:39 pm
OK, we ended up fixing this. Ran sp_MSremovedbreplication just about everywhere and emptied that table. Rebooted the server and tried again. No disco.
Tried to just make that server the distributor, worked fine. Tried to setup the publication and the subbscriber, no good.
Tried to just setup the publisher. All OK. Just set the publication database, all good. Then push the subscription. Worked OK.
If someone wants to go ahead and delete this thread that's ok by me.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply