Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

CRM and SQL reboot order?

Posted on by Microsoft Employee

Is there a preferred method of reboot the SQL and CRM application servers?  We've been seeing some SQL server error while using the application and just would like to know if it matters?

Thanks

*This post is locked for comments

  • Gee Bee Profile Picture
    Gee Bee 11,397 on at
    RE: CRM and SQL reboot order?

    Is this the page you are seeing immediately after logging into CRM?

  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: CRM and SQL reboot order?

    Well that's the thing.. it's the custom page that's not working - it's not crm. At least not according to the screenshot. You will need to check with that app developer

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM and SQL reboot order?

    I'm not sure about the custom page, I'm not the developer unfortunately. I would just like to know if this would be the cause of not restarting in the correct order? Why wouldn't SQL and CRM be able to understand when the services are up the application would work no matter the order?

  • Gee Bee Profile Picture
    Gee Bee 11,397 on at
    RE: CRM and SQL reboot order?

    This error looks like, from another asp.net application, you are using.

  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: CRM and SQL reboot order?

    Actually, what is that page you have there? It's not a CRM page - it's some custom application in an iframe within CRM..

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM and SQL reboot order?

    Understood but also in this case the errors didn't occur right away, the servers were restarted over this past weeked (4-5 days ago) and only recently started to see this SQL errors.  I'm trying to figure out if it's a result of CRM being restarted first and then SQL?

  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: CRM and SQL reboot order?

    That's not a SQL error - that's a web server error. But do you mean that all your services are started and you are still seing this error?

  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: CRM and SQL reboot order?

    Most likely that's because, if some of your CRM services are sunning when SQL is being restarted, they will try to connect to SQL and they won't be able to, so there will be a SQL error. Other than that..

    Well.. Front end server is using back end server, and back end server is using SQL. You try to stop them in the reverse order, and some of them will likely throw an error (as in.. if there is a sandbox plugin but the sandbox service has been stopped, you'll get an error.. not a SQL error, though)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM and SQL reboot order?

    8512.sql.pngThanks, I would want to know if the servers were not started in the correct order what would be the reasons for seeing SQL server error i.e. why would not restarting them in the correct order affect anything?

  • Suggested answer
    Gee Bee Profile Picture
    Gee Bee 11,397 on at
    RE: CRM and SQL reboot order?

    I would go with Andrii.

    Please also refer

    community.dynamics.com/.../124997

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans