We originally had an Active /Active-Passive Node Cluster; (SQLCLUSTER1 (S1) and SQLCLUSTER2 (S2).
After a client who needed access to SQLCLUSTER2 was unable to connect, I discovered that the TCP Ports somehow got corrupted. I couldn’t find a 1433 port. So, I obviously had to do a reinstall. NOTE: S1 contains the R and S drives (SANs). S2 contained the T and U drives (SANs as well).
I used the following site to check my install: http://www.sql-server-performance.com/articles/clustering/cluster_server_2003_p1.aspx By: Brad McGehee
While installing a failover (active/passive node) everything was going well, until I got to the Cluster Group Selection screen. Under Available cluster groups showed: Cluster Mgmt Group (this Group contains the Quorum Q drive). Under the Unavailable cluster groups showed: SQL Cluster Group (SQLCLUSTER1) – Already contains a SQL Virtual Server and the next one, SQLCLUSTER2 – Already contains a SQL Virtual Server. Under Data files: I tried to place the data on the T: drive and I received an error stating that I cannot put data on the same drive as the Quorum drive.
Prior to the reinstall of S2, I deleted/removed all SQL Server data on S2. Perhaps, this is where my problem may lie. So, my first question is, do I need to reinstall S2? My second question is, could there be
View Complete Post