Are multiple-instances on a single cluster supported with SQL Server 2005?

  • I've 2 servers with each having named instance of sql server 2005, need to check if I can get the two nodes clustered and then can I run both the instances on the 2 node cluster?

  • Not sure if you can turn 2 separate servers into a cluster from a Windows level. But from a SQL level you need to install SQL on top of the cluster and then you can certainly have 2 named instances within it

  • Yes. You can run both on a single cluster. You need to have each SQL Installs on separate Cluster Disk.

  • You need to build the Windows cluster first. Then you install SQL Server in cluster mode.

    If you now have two servers that are not in a Windows cluster, the first step is to reinstall Windows.

    If you have two SQL instances on a Windows cluster and SQL is not clustered, the first step is to uninstall SQL and reinstall it in cluster mode.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply