Quick one today:
Recently, when setting up replication on a lab machine, this error occured. Seen this error several times in the past, but never took time to blog about it.
TITLE: Configure Distribution Wizard
------------------------------
SQL Server could not retrieve information about server 'DC1REPL01'.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=CantGetInformation&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Could not find stored procedure 'sp_MSreplcheck_qv'. (Microsoft SQL Server, Error: 2812)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.00.4100&EvtSrc=MSSQLServer&EvtID=2812&LinkId=20476
We have Sql 2008 R2 for Publisher and Subscriber; And Sql 2014 for Distributor. This error occurred, when replication was being configured from the Publisher (Sql 2008 R2).
Since Distributor is Sql 2014, connecting to Distributor (Sql 2014) from a Publisher (Sql 2008 R2) has resulted in this error.
When configuring replication, we need to make sure all steps are attempted from the Management Studio (SSMS) of the latest version instance (which usually is Distributor.
Solution
This is fairly simple error to resolve.
Reattempt the actions from Distributor’s Management Studio (SSMS).
Log into Distributor machine and connect to Publisher from its Sql 2014 SSMS. Replication activities need to be performed from the instance that has the most latest SQL and SSMS versions. Since Distributor needs to be at least the same or later version of Sql compared to Publisher & Subscriber, we need to attempt these steps from Distributor’s SSMS.
_Sqltimes
Leave a Reply