Hi. I need to configure an Active Active PS configuration. I have installed the managament node and connect it to external SQL database and everything is OK for this. Now I start to configure the worker node and I need to connect this nod to the same SQL database but after I put in the credentials and the crypto key from managament node I am getting this error when click on test > Connection test failed. Could not connect to existing database. Can anyone, please, help me with this...what is the problem, what is the right way to configure an Active/active configuration 1managament/1workernode.
Answer
Active/Active Password Safe Configuration
+1Best answer by Pierre Zschocke
I saw that there was no answer to your last question. I wanted to confirm, that SQL Always On is indeed a requirement for an Active/Active environment.
https://docs.beyondtrust.com/bips/docs/bi-best-practices#activeactive-deployment-model
The steps are correct for Active Active setup, I would assume that the crypto key may have a problem. Try restarting the Management node and ensure that the webconsole can load successfully. Then try downloading the crypto key from the Management node appliance page again.
+1Thanks,I tryed that but no success for now.
One thing,maybe it is important. Do I need to have SQL Always on for this active - active config or it is enough to have a simple SQL 2019 Standard external server.
For managament node I choose Database Server in a Multi-Node Deployment from solution and for worker node I choose SQL-less Appliance like it is written in BT knowledge article
KB0020105 -
Password Safe High Availability Active Active considerations when deploying
I saw that there was no answer to your last question. I wanted to confirm, that SQL Always On is indeed a requirement for an Active/Active environment.
https://docs.beyondtrust.com/bips/docs/bi-best-practices#activeactive-deployment-model
Yes, SQL 2022 is supported in U-Series 2022 Active Active setup. You can refer to this supported platform for Password Safe.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.