Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

how to set up rms 2.0 with sbs 2008

(0) ShareShare
ReportReport
Posted on by 345

Hi,

I would like to install the RMS 2.0 in the SBS 2008 Server that had  the Sql 2005 server.  Because my windows 2008 server had the SQL 2005 in that,  When I install RMS 2.0 and skip the part to install the Sql 2005 express.  I can not connect to rmssample data base when running administrator,  it won't recognize the user sa and blank password.  Any ideas how to setup this?

Hai

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: how to set up rms 2.0 with sbs 2008

    I just upgraded sql 2000 to 2008r2. I removed the sql 200 and Reinstalled the 2008r2. You should not have any problem. Makesure you back up first and You also need to install window powershell. and You also have to install  SQL Server 2005 Backward Compatibility Componets .  www.microsoft.com/.../details.aspx 99bcb4&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.

    See link below it will help you to install the 2008

    blog.sqlauthority.com/.../sql-server-2008-step-by-step-installation-guide-with-images

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: how to set up rms 2.0 with sbs 2008

    The SQL Server installation may have a named instance of SQLEXPRESS, whereas RMS uses the default instance of MSSQLSERVER.  Go to start - run - services.msc and scroll to the SQL Server service and see the instance name.  If you are only running RMS on that SQL Server, you can install the MSSQLSERVER default instance then delete the SQLEXPRESS named instance.  Hope this helps.

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans