Thycotic Community Forum

4/15/2010 4:33:36 PM Adam D Posts: 16	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.
	0 • link
4/16/2010 3:00:20 PM Tucker Posts: 87	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: <a href="http://www.thycotic.com/documentation/secretserver/SQLServerMirroring.pdf">http://www.thycotic.com/documentation/secretserver/SQLServerMirroring.pdf</a> -- Regards, Tucker
	0 • link
4/19/2010 9:36:36 AM Adam D Posts: 16	Thank you, this is a great doc. Do you have any suggestions for setting up clustering?
	0 • link
4/20/2010 7:42:37 AM Tucker Posts: 87	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. -- Regards, Tucker
	0 • link

---