Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / What is the SQL databa...
Microsoft Dynamics RMS (Archived)

What is the SQL database format used by RMS ?

(0) ShareShare
ReportReport
Posted on by Webcharm 75

Hi everybody!

I have a situation with a client who doesn't have access to their database password (even the password for the default 'sa' user account has been changed) since their RMS installer went out of business without warning.

It's not yet a problem for everyday use of their POS equipment, but they want to run the Management software on another PC because their main database was put on the POS PC (I know!)  It's not a good situation when they want to add stock items/do inventory etc. during opening hours.

I've been trying to find software to reset the SQL server database's password, but the utilities I've found don't seem to recognise the .MDF file as being SQL 2000 or 2005.

Does anyone have any idea which version of SQL the RMS database is formatted in or what I might try doing to get my client out of this situation?

We'd prefer not to have to start from scratch inputting all the stock items!

Thanks in advance

Paul.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    Re: What is the SQL database format used by RMS ?

    You could also use a Transact SQL statement to reset the password and be done with it.

    I've had to do this on afew occasions when a hacker tried to break into the SQL server.

     

    Paulh

  • alexandre Profile Picture
    alexandre 200 on at
    Re: What is the SQL database format used by RMS ?

     There are also some freeware that show you what is behind the asterisks.

  • EricjRW Profile Picture
    EricjRW 175 on at
    Re: What is the SQL database format used by RMS ?

    Interesting. I thought I tried a registry search before... Guess it's time to give this another try.

    Thanks for the tip.

  • Community Member Profile Picture
    Community Member on at
    Re: What is the SQL database format used by RMS ?

    Even you can check password in RMS Administrator registry. That will be the plain passowrd i mean it will not be the encrypted. just check it..

     

  • EricjRW Profile Picture
    EricjRW 175 on at
    Re: What is the SQL database format used by RMS ?

    Glad to help...

    And I'm also curious as to how things work... So do post back. 

    Eric

  • Webcharm Profile Picture
    Webcharm 75 on at
    Re: What is the SQL database format used by RMS ?

    That'll be handy for when my customer forgets their next password  ;)  , but they didn't have any input into this one and so wouldn't have a clue what it might be. 

    From your idea I now have full access to the database using the Windows Authentication method. Next step is to install RMS on another PC to try making and connecting to a new version of the same database. I'll post the result when I'm done, but hopefully it should be plain sailing now.

     I'm really grateful for your help EricjRW. Thanks!

    Paul.

  • EricjRW Profile Picture
    EricjRW 175 on at
    Re: What is the SQL database format used by RMS ?

    Webcharm:

    Here's something else that might help, assuming the configuration information has not changed...

    When you do a RMS Admin / File -> Configuration / Database tab , the number of asterisks displayed is the number of chars in the pw string... That might help you or the customer remember/guess what the system admin (sa) password is...

    I just used this method on a system that was showing 8 *s...

    It took me one try to get the password!

  • Webcharm Profile Picture
    Webcharm 75 on at
    Re: What is the SQL database format used by RMS ?

    Thanks EricjRW -- I'll give that a try later this week when I'm around at my customer's site.

     

  • EricjRW Profile Picture
    EricjRW 175 on at
    Re: What is the SQL database format used by RMS ?

    What happens if you use the RMS SO Adminstrator application on the server?

    When you are actually "on the server" you can use the "use windows authentication" option. If this lets you connect to the database, you can then backup the database, so at least you will have the items in a backup file... Then, worst case, you could blow away SQL Server and reinstall (write down the password this time), and then create a new db from the backup you created.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans