Posts Tagged ‘replication’

Configuring distribution in an MSSQL Server 2005 cluster

2, Jun 2010

For some reason that you receive an error trying to configure distribution on your MSSQL Server 2005 cluster and it will ask you to use the actual server name when connecting to the server, verify that your server name in the sys.servers catalogue is the same as your instance name. To verify, while connected to [...]

Cannot recreate publication: Invalid object name ‘dbo.sysmergepublications’ in MSSQL Server 2005 replication

5, Apr 2010

This happens when you delete subscription and publication directly from Replication node in SSMS tool. Run below against the database you deleted the replication before setting it up again. USE [database] EXEC sp_removedbreplication GO

The Distributor has not been installed correctly. [SQLSTATE 42000] (Error 20036)

1, Apr 2009

Once replication is setup, the “Expired subscription clean up” job on the distributor SQL Server fails with the above error. But replication functions normally, without any problems. When you have a dedicated SQL Server 2005 distribution server, that is not publishing any of its own databases, you are likely to get this error. Workaround To [...]


top