Filed under Cluster

Installation of SQL 2005 on Windows 2003 Cluster fails with error “The drive specified cannot be used for program location. Program files must be installed on a valid local disk available on all cluster nodes”


While installing SQL Server 2005 on a windows server 2003 cluster the installation fails. After you select the Components to Install and click next we get the following error: Error Message: TITLE: Microsoft SQL Server Setup —————————— The drive specified cannot be used for program location. Program files must be installed on a valid local … Continue reading

Unable to failover a Named instance of SQL server 2005 in cluster or unable to bring a Named Instance of SQL server 2005 Online


While trying to bring the SQL Services online ,which is a named instance of SQL Server 2005, we get these error messages in the Application Event Log. Application Event Log: Event Type:       Error Event Source:    MSSQL$SQL2k5 Event Category: (3) Event ID:          19019 Date:                7/17/2009 Time:                7:12:00 AM User:                N/A Computer:         BLRS2R17-3 Description: [sqsrvres] ODBC sqldriverconnect … Continue reading