Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee 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

  • Verified answer
    Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 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.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans