Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

Database connection error

Posted on by 205

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"

Notes:

Windows server 2012

SQL Server 2008

*This post is locked for comments

  • NickZnavor Profile Picture
    NickZnavor 715 on at
    RE: Database connection error

    Dont have to install 2005 server at all if u are using 2008. Just install the bc for either x86 or 64

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Database connection error

    Do you have to have the sql 2005 express installed 1st before the backward compatibility? this is a new build pointing at sql 2008, trying to do the CU5 update.

    thanks

  • Suggested answer
    arishi Profile Picture
    arishi 740 on at
    RE: Database connection error

    Hello Ricardo

    below is the link to download

    download.microsoft.com/.../SQLServer2005_BC.msi

  • Suggested answer
    arishi Profile Picture
    arishi 740 on at
    RE: Database connection error

    Hi,

    is this a new installation?

    did you install SQL 2005 Express while RMS installation?

    RMS SOA Server:- YOUR-SERVERNAME\SQLEXPRESS

    make sure use the same user name and password that you assign while installing SQL

  • Ricardo Funes Profile Picture
    Ricardo Funes 115 on at
    RE: Database connection error

    how can i get the sql server 2005 backward compatibility, could you help me with it i have problems because a change sql 2005 to sql 2008 r2, a can't connect with administrator

  • coupet Profile Picture
    coupet 205 on at
    RE: Database connection error

    Works after Install SQL Server 2005 Backward Compatibility

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans