none
Missing Database Services when installing 2005 SP3 on multi-instance server

    Question

  • Hi,

    When trying to install SP3 on a server with about 7 instances on it we get the feature selection dialog box but we cannot pick which instance to upgrade see below.

     

    Any ideas?? The server is Windows 2003 SP2 Ent. x86

     

    Thanks, Alex.

    Tuesday, November 09, 2010 12:30 PM

Answers

  • Rebooted the server and all is well. I could remove the old instance and see all existing instances in the SP3 installer.

    Thanks for all your help

    Wednesday, November 10, 2010 1:51 PM

All replies

  • Hello,

    Please run the following command on each instance:

    SELECT @@version

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Tuesday, November 09, 2010 12:54 PM
    Moderator
  • Hi,

    Following is the information requested. Thanks, Alex.

    Instance 1
    Microsoft SQL Server 2005 - 9.00.3073.00 (Intel X86)   Aug  5 2008 12:31:12   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Instance 2
    Microsoft SQL Server 2005 - 9.00.3073.00 (Intel X86)   Aug  5 2008 12:31:12   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Instance 3
    Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)   Oct 14 2005 00:33:37   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Instance 4
    Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)   Oct 14 2005 00:33:37   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Instance 5
    Microsoft SQL Server  2000 - 8.00.2050 (Intel X86)   Mar  7 2008 21:29:56   Copyright (c) 1988-2003 Microsoft Corporation  Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 2)

    Instance 6
    Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)   Oct 14 2005 00:33:37   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Instance 7
    Microsoft SQL Server 2005 - 9.00.3073.00 (Intel X86)   Aug  5 2008 12:31:12   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Instance 8
    Microsoft SQL Server 2005 - 9.00.3073.00 (Intel X86)   Aug  5 2008 12:31:12   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Instance 9
    Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)   Oct 14 2005 00:33:37   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Tuesday, November 09, 2010 1:03 PM
  • Hello,

    Please see the following article, about requirements to install SP3:

    http://www.sqlcoffee.com/Tips0007.htm

    Hope this helps.   
     
    Regards,

    Alberto Morillo
    SQLCoffee.com

    Tuesday, November 09, 2010 1:33 PM
    Moderator
  • Thanks,

    i'm running the installation as a domain admin, there is pleanty of disk space.

    Anything further?

    Thanks again. Alex.

    Tuesday, November 09, 2010 3:59 PM
  • Hi Alex_Harvey,

     

    It seems that the installation program failed to retrieve the information of every instance of SQL Server 2005.

    This issue might be caused by some third party software. I would like to recommend that you temporarily disable all other applications, especially Anti-Virus software and Firewall, and try again.

    Meanwhile I would like to recommend that you check the status of this installation file. Please right-click on this file and check if it is locked. If it is locked, please click Unlock button to unlock it and click OK.

     

    If anything is unclear, please let me know.


    Regards,
    Tom Li
    Wednesday, November 10, 2010 5:50 AM
    Moderator
  • Hi Alex_Harvey,

    This issue might be caused by that the installation file of SP3 is corrupt.

    I would like to recommend that you download SQLServer2005SP3-KB955706-x86-ENU.exe from the following link and try again:

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en


    Regards,
    Tom Li
    Wednesday, November 10, 2010 9:40 AM
    Moderator
  • SP2 also fails to list instances. I've disabled antivirus and all other non essential programs but still no joy.
    Wednesday, November 10, 2010 9:54 AM
  • We use WMI to detect the installed instances. Try below

    1. Use c:\windows\System32\wbem\wbemtest.exe and connect to NameSpace root\Microsoft\SqlServer\ComputerManagement
    2. Run WQL - Select * from SQLService and check if you see instance services?
    3. Run WQL - Select * from RegServices and check if you see services?

    I would suggest to contact Microsoft SQL support team via support case.
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Wednesday, November 10, 2010 9:57 AM
    Moderator
  • Downloaded the installer again but still the same.

    Running the two querys against WMI gives me the results i expect. SQLService listing all instances and SQLAgent services etc. and Reg services listing the main SQL services excluding instances.

    Thanks again.

    Wednesday, November 10, 2010 10:08 AM
  • Could you please keep log files on internet and let us know the location.
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Wednesday, November 10, 2010 11:58 AM
    Moderator
  • I think i've tracked the issue down to bad WMI. If i try and remove an old instance i get the following error:

    The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <machinename> Error:2147749891 (0x80041003)

    I have rebuilt WMI several ways and times. the final way was a follows:

    @echo on
    cd /d c:\temp
    if not exist %windir%\system32\wbem goto TryInstall
    cd /d %windir%\system32\wbem
    net stop winmgmt
    winmgmt /kill
    if exist Rep_bak rd Rep_bak /s /q
    rename Repository Rep_bak
    for %%i in (*.dll) do RegSvr32 -s %%i
    for %%i in (*.exe) do call :FixSrv %%i
    for %%i in (*.mof,*.mfl) do Mofcomp %%i
    net start winmgmt
    goto End

    :FixSrv
    if /I (%1) == (wbemcntl.exe) goto SkipSrv
    if /I (%1) == (wbemtest.exe) goto SkipSrv
    if /I (%1) == (mofcomp.exe) goto SkipSrv
    %1 /RegServer

    :SkipSrv
    goto End

    :TryInstall
    if not exist wmicore.exe goto End
    wmicore /s
    net start winmgmt
    :End

    The error still happens.

    i'm happen to give log files but would like to which ones.

    Any further ideas?

    Alex

    Wednesday, November 10, 2010 12:52 PM
  • Rebooted the server and all is well. I could remove the old instance and see all existing instances in the SP3 installer.

    Thanks for all your help

    Wednesday, November 10, 2010 1:51 PM