URGENT: Named Instances

  • we have SQL Server 2005 EE installed as the default instance and has SP 2 applied.  We are attempting to go back to SQL Server 2005 EE with SP 1 by installing a named instance SQL Server 2005 EE.  I have successfully installed SQL Server 2005 EE RTM, but when attempting to install SP 1, it fails as it is also trying to apply SP 1 to the default instance.  I need to apply SP 1 to only our named instance.  Any help is greatly appreciated.

    Thanks

  • In the Wizard there should be a selection to apply to all instances or to the specific instance

    Regards,Yelena Varsha

  • It is greyed out.  All it wants to do is apply SP 1 to all instances.

     

  • Also just tried this:

    SQLServer2005SP1-KB913090-x86-ENU.exe /quiet /norestart /instancename=HCM

    This is what I got in the log file:

    06/19/2007 10:20:10.627 ================================================================================

    06/19/2007 10:20:10.627 Hotfix package launched

    06/19/2007 10:20:13.314 Product discovery successfully completed during the install process for HCM

    06/19/2007 10:20:13.314 SP Level check successfully completed during the install process for HCM

    06/19/2007 10:20:13.314 Product language check successfully completed during the install process for HCM

    06/19/2007 10:20:13.314 Product version check successfully completed during the install process for HCM

    06/19/2007 10:20:13.346 Product discovery successfully completed during the install process for MSSQLSERVER

    06/19/2007 10:20:13.361 This update requires service pack 0,1. The service pack for product instance MSSQLSERVER is 2. Download the update for service pack 2.

    06/19/2007 10:20:13.361 Command-line instance name check completed during the install process

    06/19/2007 10:20:13.361 Baseline build check completed during the install process

    06/19/2007 10:20:29.642 Hotfix package closed

    Even with the /instancename switch, it still looks like it is trying to apply to all instances.

  • Lynn,

    EE is Express Edition or Enterprise Edition?

    I assumed it was Enterprise but if it is Express then I think you download the Express Edition SP1 from here:

    http://www.microsoft.com/downloads/details.aspx?familyid=11350B1F-8F44-4DB6-B542-4A4B869C2FF1&displaylang=en

    Also in the Readme for some reason the instance name is in quotes:

    http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQLEXP2005.htm

    Regards,Yelena Varsha

  • When I use EE, I mean Enterprise Edition.

    I will reread the readme, but I didn't put the instance name in quotes when I tried it, as the help file I was reading didn't indicate that it needed to be, of course there was no sample code either.

    Thanks,

    Lynn

Viewing 6 posts - 1 through 6 (of 6 total)

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