We have observed a number of cases where the installation of the sql server 2005 instance on the cluster fails with the following unexpected Failure Error Message while performing SCC checks. ERROR MESSAGE: ==================== There is unexpected failure. MSGID 50000 In order to troubleshoot the issue we followed the following steps 1) We… Continue reading SQL Server 2005 Setup Failing to Install on Cluster with Unexpected Failure while Performing the SCC checks
In sql server the default instance has a listener which listens on the fixed port which is TCP port 1433. However for the named instance the port on which the sql server listens is random and is dynamically selected when the named instance of the sql server starts. So when we connect to… Continue reading HOW TO CHANGE THE DYNAMIC PORT OF THE SQL SERVER NAMED INSTANCE TO THE STATIC PORT IN A SQL SERVER 2005 CLUSTERED INSTANCE
This post talks about the location of the log folder where all the sql server 2005 setup logs are located. It mainly provides the solution of the error 29506 during installation of the sql server sp2.