Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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"

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"

Symptoms

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).

↑ Back to the top

Cause

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.

↑ Back to the top

Resolution

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.

↑ Back to the top

Keywords: kberrmsg, kbsurveynew, kbmbspartner, kbexpertisebeginner, kbtshoot, kbmbsmigrate, kbprb, kbexpertiseinter, kb

↑ Back to the top

Article Info
Article ID : 971665
Revision : 1
Created on : 1/7/2017
Published on : 8/4/2011
Exists online : False
Views : 101