Post reply

Issue Installing Service Pack 3 on 2005 Cluster

  • August 26, 2010 at 7:28 am

    #387666

    I am trying to deploy SQL Server Service Pack 3 on a new 2005 Failover Cluster. The problem I am having is that regardless of whether I run the installer on the active or passive node, the 'Database Services' option is never available. I have also tried to do the deployment with the command line switches, however have not had any luck so far. Any thoughts?

  • August 31, 2010 at 9:26 am

    #1214404

    Anyone have any ideas? Anyone? Anyone?

  • September 1, 2010 at 7:05 am

    #1214918

    What's the current version?

    SELECT CAST( SERVERPROPERTY( 'MachineName' ) AS varchar( 30 ) ) AS MachineName ,

    CAST( SERVERPROPERTY( 'InstanceName' ) AS varchar( 30 ) ) AS Instance ,

    CAST( SERVERPROPERTY( 'ProductVersion' ) AS varchar( 30 ) ) AS ProductVersion ,

    CAST( SERVERPROPERTY( 'ProductLevel' ) AS varchar( 30 ) ) AS ProductLevel ,

    CAST( SERVERPROPERTY( 'Edition' ) AS varchar( 30 ) ) AS Edition ,

    ( CASE SERVERPROPERTY( 'EngineEdition')

    WHEN 1 THEN 'Personal or Desktop'

    WHEN 2 THEN 'Standard'

    WHEN 3 THEN 'Enterprise'

    END ) AS EngineType ,

    CAST( SERVERPROPERTY( 'LicenseType' ) AS varchar( 30 ) ) AS LicenseType ,

    SERVERPROPERTY( 'NumLicenses' ) AS #Licenses;

  • September 1, 2010 at 8:52 am

    #1215041

    Make sure you log on to the cluster with the account that runs the Cluster Service. I have successfully installed service pack 3 on a cluster. I logged on to the active node first, and then repeated the installation on the passive node.

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

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