web
You’re offline. This is a read only version of the page.
close
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) / Can't connect to d...
Microsoft Dynamics RMS (Archived)

Can't connect to database

(0) ShareShare
ReportReport
Posted on by Chad Simmons 416

I've been having issues with my install of RMS 2.0.1006

We migrated to a new computer running SQL Server Express 2008 R2

Everything has been running fine for months now. Recently though we had a power outage and when I rebooted the computer I couldn't get any of the RMS programs to run. I got a error popup that a database connection could not be made. I have to reboot the computer and it connects fine again. This happens from time to time randomly

Event viewer shows this errors:

A timeout was reached (30000 milliseconds) while waiting for the SQL Server (SQLEXPRESS) service to connect.

Event ID 7009

The SQL Server (SQLEXPRESS) service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.

Event ID 7000

The SQL Server Agent (SQLEXPRESS) service depends on the SQL Server (SQLEXPRESS) service which failed to start because of the following error:
The service did not respond to the start or control request in a timely fashion.

Event ID7001

Any input on what I need to do to fix this issue?

*This post is locked for comments

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

    Please check this :

    support.microsoft.com/.../558119

  • Suggested answer
    Nicole Hellerud Profile Picture
    Nicole Hellerud 1,712 on at

    Hello Chad,

    Thank you for your post.

    I have seen this issue before, but what I generally do to fix it is to reinstall SQL.

    Please let me know whether you have any questions.

    Thanks,

    Nicole

  • Chad Simmons Profile Picture
    Chad Simmons 416 on at

    I changed the timeout as suggested in the help article and so far the event log is clear of these issues. If they recur, I'll try reinstalling SQL. Will reinstallation leave my databases intact?

    Thanks.

  • Suggested answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at

    Hi Chad.

    Make database backups before re-istalling SQL Server! Re-estalling should not affect your database files, but... actual SQL installation could have been installed differently then the standard install option, so You better make a backup and recover it in the new SQL instance...

    Kind regards, A.

  • Nicole Hellerud Profile Picture
    Nicole Hellerud 1,712 on at

    Hello Chad,

    Thank you for your update.

    Reinstalling SQL will remove any current database files. I would suggest creating a backup of all database files prior to reinstalling SQL.


    I look forward to your update.


    Thanks,

    Nicole

  • Chad Simmons Profile Picture
    Chad Simmons 416 on at

    The issue has recently recurred. I found that I can manually start the SQL Server from the Services page. Evidently, it is sometimes unable to start with Windows. I'm not sure what the culprit could be.

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

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