June 19, 2007 at 10:08 am
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
June 19, 2007 at 10:14 am
In the Wizard there should be a selection to apply to all instances or to the specific instance
Regards,Yelena Varsha
June 19, 2007 at 10:24 am
It is greyed out. All it wants to do is apply SP 1 to all instances.
June 19, 2007 at 10:36 am
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.
June 20, 2007 at 9:50 am
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:
Also in the Readme for some reason the instance name is in quotes:
Regards,Yelena Varsha
June 20, 2007 at 6:09 pm
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