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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / database not found
Microsoft Dynamics RMS (Archived)

database not found

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member 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
    TheNeos 1,347 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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September 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