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
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
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.
You would use a server name and DNS..
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
Is your IP dynamic? If you are clustering, yes you would want to point to the SQL listener
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156