Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

database not found

(0) ShareShare
ReportReport
Posted on by

We had our router replaced today and all of a sudden I am getting a "database not found" error message when trying to open POS. I figured it would a network issue, but everything in pingable to the server with mapped network drives working as expected.

I went over to the server and tried to login, same error message. Locally it doesn't work either.

On the server I went to the store operations administrator and tried to login with windows authentication. When I do, I get the following error message: 

error1.PNG

I then opened the SQL Management Studio and logged in with window authentication and try to expand out the RMS database. I get the following error message:

error2.PNG

I'm at a loss here. What should I be looking for?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: database not found

    Can you access the database on the computer is it located on? Replacing a router should not have effected the database machine considering that the database is local to that machine. If you can access the database on this machine then you would  just need to make sure that all other machines in your environment can see the DB machine and gain access to it.

    1. Check the DB machine IP.

    2. Check the Windows Firewall

    3. Check the router to see if the needed ports are forwarded.

    4. Pinging the DB machine is a good way to tell if your other computers can see the DB machine.

    5. On the DB machine open "Run" Type Services.msc>click into the name column and hit the "s" key and look for SQL EXPRESS Service (Not the Agent) Right click on the service and make sure it is running.

  • Suggested answer
    TheNeos Profile Picture
    1,345 on at
    RE: database not found

    Hello,

    It seems that you should connect with SQL Authentication.

    If you have forgotten this PW you can reset it with SQL Server Management like this:

    You need to write down your new PW as you will not see as you type.

    Start and log in SQL Management studio as sa,

       On Object Explorer select Security,>  Loggins ,> sa,

           here you can set a new PW for the server. Write it down and enter it.

        Default database is Master.

    Use SQL authentication with RMS Administrator to connect and once connected test the connection. Once tested  OK RMS Manager and POS should be working.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March 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... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,017 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans