question

iftekhar_ilm avatar image
iftekhar_ilm asked

Not able to connect to the distributor while configuring transactional replication

I need to setup transactional replication, the publisher is SQL Server 2012 Enterprise edition and the distributor is SQL Server 2017 Standard edition. I am trying to add the distributor, from the distributor configuration wizard when I try to connect to the distributor, it fails saying- "SQL server could not retrieve information about server 'SERVER NAME', Could not find stored procedure sp_MSreplcheck_qv Error: 2812". However we have been able to add this distributor for other publication servers. I found a site where people has mentioned the solution for it but that doesn't work for me. I have been exploring Google but not able to find the solution. Any help would be highly appreciable.

sql server 2012transactional-replication
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
iftekhar_ilm avatar image
iftekhar_ilm answered

The problem was I was using an older version of SSMS, I switched to a newer version and I was able to add the distributor successfully.

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image Magnus Ahlkvist commented ·

Thanks for sharing the solution to your problem, even though you found out yourself. That might help people with the same issue in the future. Well done!

0 Likes 0 ·
Swilling avatar image
Swilling answered

Yes, with replication is has to be with in 2 versions.

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image anthony.green commented ·

That’s only correct for the publisher and subscriber.

the distributor just needs to be higher or equal to the publisher.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.