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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Microsoft Dynamics Ret...
Small and medium business | Business Central, N...
Suggested Answer

Microsoft Dynamics Retail Management System Store Operations v2

(2) ShareShare
ReportReport
Posted on by CU28092055-0 18
Hello. I know this software is ancient. But I have a client who still uses it. And he's running into SQL errors while using it. So I was going to try to update his SQL server express version from 2005 to version 2008. I've read that this requires sp2 for MDRMSSO. And, as you might imagine, I can't download that anywhere. Can anyone help me out in locating it, downloading it? Thanks in advance.
I have the same question (0)
  • CU29091431-0 Profile Picture
    CU29091431-0 3 on at
    Back in 2019 I found a site with all the RMS related downloads. Just checked and it's still there: https://bcposgroup.com/rms/
     
  • CU30091909-0 Profile Picture
    CU30091909-0 8 on at
    I am using RMS and running it on SQL Server 2022. 
    What version RMS are you running?  What are the SQL Errors you are receiving?
    Maurice at  NWBussolutions.com
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,417 Super User 2026 Season 1 on at

    Hi CU28092055-0,

    You're right — Microsoft Dynamics RMS Store Operations v2 is quite dated, and compatibility with newer SQL Server versions can be tricky. To upgrade from SQL Server Express 2005 to 2008, you’ll indeed need Service Pack 2 (SP2) for RMS Store Operations.

    Here are a few suggestions:

    1. Check Microsoft Lifecycle Downloads: Sometimes older service packs are archived in Microsoft’s lifecycle or support download centers.
    2. Contact Microsoft Support: Even for legacy products, Microsoft support may be able to provide access to SP2 upon request.
    3. Community Archives: Some long-time RMS users or partners may have archived versions. Try reaching out on RMS-specific forums or LinkedIn groups.
    4. Backup First: Before upgrading SQL Server, ensure you have a full backup of both the database and RMS installation.

    Let me know if this helps!
    If the answer was useful, please mark it as helpful so others can benefit too. 😊

    Best regards,
    Daniele Incalza

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,804 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,103 Super User 2026 Season 1

#3
Kamal Khakhkhar Profile Picture

Kamal Khakhkhar 695

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans