SQL Server Performance Forum – Threads Archive

Cluster Configuration

If I install a two node cluster with the MS SQL 2005 default instance on node 1 and a named instance on node 2 is this considered and active/active configuration? Both nodes will have active databases. Thanks.

---

For each instance you should have the SQL Server and the SQL Server Agent services on every node. So, for an active/active installation that means two SQLSERVER services, and two SQLSERVERAGENT services in service manager. If not, you haven’t got an active/active cluster. Get a clarification for your doubts fromhttp://www.sql-server-performance.com/bm_cluster_sql_server_2005.asp link Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

Check the following too…
http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlclusters/default.aspx
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

]]>