Secret Server

I found a few entries about DB mirroring and an old document about IIS Load Balancing but nothing about Clustering

Is W2k8/SQL2k8 Failover Cluster supported? (Shared Storage)
Is IIS7 Loadbalancing supported?

Thanks and regards
Tom

Hello Tom,

Secret Server does support the SQL 2008 Failover Cluster. Since a SQL Server failover cluster appears on the network as a single SQL Server instance on a single computer, Secret Server will interact with the cluster as if single database.

Secret Server does not support IIS7 Loadbalancing. I can add that has a feature request, if needed.

Regards,
Tucker

Hello Tucker

Thanks for the Answers!

Is loadbalancing in general no option anymore? (IIS6?)
In the Document:http://www.thycotic.com/documentation/secretserver/DBFailoverForSecretServer.pdf
is a constellation with two Frontends described, but with Web/SQL combined plus 2 Database Servers as backend.
What for is the SQL on the Webserver needed? A coexistence of SQL and IIS on the same machine is not a recommended configuration in cause of security issues...

We can start with a single frontend for pilot, but in the future we will need a fully redundant solution.

Thanks and regards
Tom

Hello Tom,

It is possible to run Secret Server with two web servers but there are a few caveats such as during upgrades you will need to manually update one of the servers. We have a feature request to improve our support for multiple webservers but we don't have a set release for that feature.

The SQL Server does not need to be on the web server. Through mirroring, the multi-backend SQL Servers is supported.

high availability would be great, thanks for letting us know it is on the roadmap

Jon,

Just to clarify ... high availability is supported in Secret Server today and has been for some time.

Configuring database failover for Secret Server (Summary)
http://www.thycotic.com/documentation/secretserver/DBFailoverForSecretServer.pdf

Setting up Secret Server for disaster recovery
http://support.thycotic.com/KB/a58/setting-up-secret-server-for-disaster-recovery.aspx

The upcoming feature that Tucker mentioned is the ability to support clustering of the front-end webservers. Our current high availability only involves the backend database. Look for front-end clustering support in the 7.0 or 7.1 release.

Best.