web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / error to connect this...
Microsoft Dynamics RMS (Archived)

error to connect this server use must use sql server management stdio or sql server management object

(0) ShareShare
ReportReport
Posted on by Community Member

I just removed my sql server  200 and  reinstalled sql server 2008 r2. and I restored my back by using tab sql sever 2008r2 studio.

when I opened store opration administrator  under the configuration  data test is successfull and I can open POS and manger on sever no problem But when I  click on administrator to connect the data i get error "to connect this server use must use sql server management stdio or sql server management object(smo)"

Any one know where is mistake ?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at
    Re: error to connect this server use must use sql server management stdio or sql server management object

    Harjit,

    You must install the SQL Server 2005 Backward Compatibility Componets from here, about 1/3 of the way down:

     http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4&displaylang=en

    The x86 version is for Windows 32 bit, x64 is for 64 bit. Don't mess with the IA64 version.

     

    When you run it, you can select all of the options, but all you really need is just the line ending in SQL-DMO  which I think is the second one down.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: error to connect this server use must use sql server management stdio or sql server management object

    If you OS is 2003 or early version then the SQL Server Backward Comparability will work fine if you have higher version like 2008 it will not work and i am still searching for a different solution.

    Anyway Link for BC 2005 is : download.microsoft.com/.../SQLServer2005_BC.msi

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans