Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

RMS Could Not Connect To Database

Posted on by 35

I removed all instances of SQL Server, I removed RMS, I removed the file folders and checked the registry, rebooted, and I installed RMS again and let it install SQL Server 2005.  I can connect to the database through administrator but when I try to login to Store Manager I get a Could Not Connect To Database.  How do I fix this?

*This post is locked for comments

  • Gerald Rothaus Profile Picture
    Gerald Rothaus 2,930 on at
    Re: RMS Could Not Connect To Database

    Sounds like you have a password login error. Open sql manager (you can download it from microsoft if you don't have it) and login into your sql server with your windows login. Add a user to the logins in sql server, giving it public access. That will work in rms. Google adding a user to sql 2005 if you can't sort it out.

    -Jerry

  • Re: RMS Could Not Connect To Database

    Hello Corey,

    Thank you for your questions.

    Have you set the Server Name and Database in Store Operations Administrator Configuration?

    1) Log into Store Operations Administrator

    2) Click on File | Configuration

     

    For more information, please see the Microsoft Dynamics RMS Store Operations 2.0 Getting Started Guide.

    https://mbs.microsoft.com/downloads/customer/RMS_SO_GS_Guide_V2.pdf

    Let us know if that helps or if you have any questions.

     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans