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

Notifications

Announcements

Season of Giving Solutions is Here!
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

I have the same question (0)
  • EricjRW Profile Picture
    EricjRW 175 on at

    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.

  • Webcharm Profile Picture
    Webcharm 75 on at

    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

    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

    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

    Glad to help...

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

    Eric

  • Community Member Profile Picture
    Community Member on at

    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

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

    Thanks for the tip.

  • alexandre Profile Picture
    alexandre 200 on at

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

  • Community Member Profile Picture
    Community Member on at

    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

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans