Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Setting up Dynamics to connect to Availability Group or SQL Listener

Posted on by 25

Hi All

Does anyone know if you can setup Dynamics on HA via SQL 2016 and above

is it a case of adding in the listener for the connection config or do i need to point it directly to a server?

Thanks

*This post is locked for comments

  • Suggested answer
    JasonBenedetti Profile Picture
    JasonBenedetti 30 on at
    RE: Setting up Dynamics to connect to Availability Group or SQL Listener

    Install 2016 as you would normally, get it running and updating against a single node in the cluster (e.g. SQL01 and SQL02 are setup to be HA - Do the CRM install against SQL01 when installing). When everything is running change the DB to the cluster address (e.g. SQL-LISTENER-01), registry/DB config settings

    Now I've not done an on-prem install in a while, so if you can directly point the installation at a cluster do it that way. Above works and is what we did when we migrated to a SQL cluster.

    Standard things apply, changing config/registry settings are at your own risk. etc.

  • bac26 Profile Picture
    bac26 2,268 on at
    RE: Setting up Dynamics to connect to Availability Group or SQL Listener

    You would use a server name and DNS..

  • SteveKnowles Profile Picture
    SteveKnowles 25 on at
    RE: Setting up Dynamics to connect to Availability Group or SQL Listener

    Hi Beth

    Thanks for the reply

    With regards to the IP, it wouldn't be dynamic

    Is it possible to amend the setup of a current dynamics config to point to a SQL listener instead of a server?

    Thanks

  • bac26 Profile Picture
    bac26 2,268 on at
    RE: Setting up Dynamics to connect to Availability Group or SQL Listener

    Is your IP dynamic?   If you are clustering, yes you would want to point to the SQL listener

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans