1

Can you please help me to configure a CMS for failover db( MS SQL 2014 ), where do I need to setup CMS db for failover DB. I tried to change under Database settings but it works only with manual switching under SDL Web Content Manager console.

Thanks in advance!!!

Anand

0

SQL server 2012 onward provides feature of the listener. The role of the listener is to identify the primary database and replica database. Listener will always direct the traffic to the primary database.

In the SDL web configuration, instead of giving database server name, provide listener name and you should be good to go with.

We had the similar setup and it worked fine with failovers as listener will keep track.

Article to setup listener can be found here

|improve this answer|||||
  • Thanks for your answer , I will try this and let you know... – Naveen Anand Apr 19 '17 at 5:43
2

Not really a question that is (only) related to SDL Web, since it is directly related to the database in question.

So you should really follow the documentation of the database vendor here, I found the following link for you:

https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/install/create-a-new-sql-server-failover-cluster-setup

If you want to know how to specify the database connection settings, that is done in the SDL Web Content Manager configuration (MMC Snap-in), more details are to be found in the documentation: http://docs.sdl.com/LiveContent/content/en-US/SDL%20Web-v5/GUID-64A87325-CCDC-44F5-968A-B7589F94E90B

|improve this answer|||||
  • Thanks for your comment !!! I have already setup of fail-over database, only the question is where can I define the connection string for CM? – Naveen Anand Apr 11 '17 at 8:32
  • @NaveenAnand can you edit your question and update it with that specific information, that will allow you to get more detailed answers. – Bart Koopman Apr 11 '17 at 8:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.