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 characters needed characters left characters exceeded

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

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 characters needed characters left characters exceeded

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

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 characters needed characters left characters exceeded

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

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.