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

Нужна дополнительная помощь?

Совершенствование навыков
Перейти к обучению
Первоочередный доступ к новым возможностям
Присоединение к программе предварительной оценки Майкрософт

Были ли сведения полезными?

Спасибо за ваш отзыв!

Благодарим за отзыв! Возможно, будет полезно связать вас с одним из наших специалистов службы поддержки Office.

×