Error message when you try to connect to a store database server from Microsoft Dynamics RMS Store Operations Administrator: "To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects"

When you try to connect to a store database server from a client that is running Microsoft Dynamics Retail Management System (RMS) Store Operations Administrator, you receive the following error message:

To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO).

Symptoms

This problem occurs for one of the following reasons:

  • The version of Microsoft SQL Server that is running on the client is earlier than version of Microsoft SQL Server on the server.

  • Microsoft SQL Server is not installed on the client.

  • Microsoft SQL Server 2005 Backward Compatibility is not installed on the client.

Cause

To resolve this problem, install the Microsoft SQL Server 2005 Backward Compatibility stand-alone package. To do this, follow these steps:

  1. Download the Microsoft SQL Server Backward Compatibility stand-alone package. To do this, visit the following Microsoft Web site:

    http://download.microsoft.com/download/f/7/4/f74cbdb1-87e2-4794-9186-e3ad6bd54b41/SQLServer2005_BC.msi

  2. Double-click the SQLServer2005_BC.msi file that you downloaded in step 1, and then follow the Microsoft SQL Server Backward Compatibility Installation Wizard to install Microsoft SQL Server Backward Compatibility.

  3. Restart the client after you install Microsoft SQL Server Backward Compatibility.

Resolution

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×