sp_msreplcheck_qv error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Replication (2008)

sp_msreplcheck_qv error

Author

Topic

TessZA
Starting Member

7 Posts

Posted - 2009-10-14 : 06:17:39

Hi there

I am trying to test replication through SQL Server 2008.
We use replication extensively in our SQL environment and I have been working with replication for a long time, but am completely at a loss with this problem. Please can someone help or ANY suggestions on what I can try to solve the error.

Scenario:
1. Server 1: I have set up a server as a distributor. Win Server 2008 64-bit, SQL Server 2008 64-bit Standard Ed SP1. Configured the server as a distributor with no issues.

2. I have set up 2 servers that will serve as publishers for the testing.
Server2: Win Server 2003, SQL Server 2000 Standard SP4
Server3: Win Server 2003 64-bit, SQL Server 2005 Standard 64-bit SP3

When I try to add Server1 as the distributor for either Server2 or Server3, I get the error "Could not find stored procedure 'sp_replcheck_qv'."

The following scenarios do work however:
1. I can add Server1 as the distributor for one of our production SQL Server 2008 servers.
2. I can add one of our production distribution servers (SQL 2005) as the distributor for both Server2 & Server3.

I've been struggling with this issue for a while and I'm pretty sure I'm missing something, but have no idea what.

Pleae can someone help.

Thanks,
Tess

vishal.todkar
Starting Member

20 Posts

Posted - 2009-12-01 : 00:15:02

Hi Tess
Similar issue I am getting and all my servers are Win Server 2008 64-bit, SQL Server 2008 64-bit Standard Ed SP1.
All my setup works fine in Win Server 2003, SQL Server 2005 Standard Ed SP3.

We have Sites running under Merge and Transactional Replication. These are using SQL Server 2005 SP3 Standard edition on Windows Server 2003 machines.

Our new requirement is migrating setup
From Windows 2003 Server – SQL Server 2005 SP3 Standard Edition
To Windows 2008 Server R2 64 bit– SQL Server 2008 64 bit SP1 Standard Edition

Could you please provide me necessary steps, suggestions, do’s and don’t?
Thanks in advance.

Vishal

bkshaw
Starting Member

1 Post

Posted - 2009-12-04 : 20:31:58

I had the same problem and solved it by doing all of the work from Management Studio 2008. Use this and connect to your lower versions of SQL and it should work fine.

Good Luck,

Brian

virenmann
Starting Member

1 Post

Posted - 2010-07-21 : 13:23:40

I am sure you will not see the error with the process I follow.

This is all you need to do:

1. Open SSMS SQL 2008
2. Connect or register to all the server in SSMS
3. Configure Publisher and connect to Distributor

Note: Distributor should always be on higher version of SQL Server.

If you have any questions or problem in Replication, Mirroring, Logshipping and clustering, please feel free to email me.

Thanks
Virender M.
MCDBA, MCTS, MCITP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources