Thycotic Community - Secret Server - SQL Clustering help - Messages

Message from Tucker

Tue, 20 Apr 2010 07:42:37 GMT

Hello Adam,

One of the gotchas is the same Service Account needs to be running the SQL servers on all three machines (Primary, Secondary, Witness). The primary and the secondary will need to be full version of SQL Server for the mirroring capabilities but the Witness can be SQL Express.

Message from Adam D

Mon, 19 Apr 2010 09:36:36 GMT

Thank you, this is a great doc. Do you have any suggestions for setting up clustering?

Message from Tucker

Fri, 16 Apr 2010 15:00:20 GMT

Hello Adam,

Secret Server supports failover with SQL Mirror configuration. Best practices for a high availability instance would a primary, mirror, and witness server to automatically failover when needed. More technical details on setting up Secret Server mirroring can be found here:
http://www.thycotic.com/documentation/secretserver/SQLServerMirroring.pdf

Message from Adam D

Thu, 15 Apr 2010 16:33:36 GMT

Hi, we are thinking of setting up MS SQL clustering and was wondering if Thycotic has any suggestions on best practices in installing and configuring clustering.