SQL Server Performance Forum – Threads Archive

Error – Installing client tools – SQL Server 2005

Hello I am trying to install client tools on my desktop and I am getting the following error : Edition Change Check (Warning) Messages
Edition Change Check
To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005,
you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter. This error , I am have seen in the logs. The installation wizard is closing down with the above log error. Thanks

It means that you have to perform the install from the command line. Via cmdshell, cd to your setup.exe directory and call "setup.exe SKUUPGRADE=1" and it’ll start the setup again.

hello haywood thanks for the information. Can you please tell me in detail of how to go about it. As this is the first time I am doing it and not really sure about the cmdshell . Thanks in advance

What the error says is there is already a SQL Server 2005 instance in that box and u r installing a new instance of another Edition of SQL 2005 now. Is there any instance already there? check in services.. it may not be started… Madhu

There is nothing related to sql server 2005 in the services. Thanks

There might be some installation… you can following the manual unisatllation steps…
http://support.microsoft.com/kb/909967 http://msdn2.microsoft.com/en-us/library/ms144259.aspx#installationscripts
Mohammed U.

Hi,
as the error said might be their is a Natice Client already installed in your system , does your system have VS installed!!! It has SQL Express which get installed with VS . Kindly re-ensure. Regards Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
————————
http://hemantgirisgoswami.blogspot.com

If you are already running with SQLExpress tools and trying to install SSMS, then you have to uninstall SSMSE and then reinstall SSMS tools. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

I have uninstalled everything related to sql server and have cleared up everything from the add/remove programs and started the installation of the sqlserver 2005 client tools. But I am still struck. The log file shows: Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Fri Jan 05 10:52:10 2007 DEPAUL-EF4AE0A7 : There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Fri Jan 05 10:54:59 2007
List of log files:
C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_Core(Local).log
C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_Datastore.xml
C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_.NET Framework 2.0.log
C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_Core.log
C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_.NET Framework 2.0 LangPack.log
C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_.NET Framework Upgrade Advisor.log
C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_.NET Framework Upgrade Advisor LangPack.log
C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_.NET Framework Windows Installer.log
C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_.NET Framework Windows Installer LangPack.log
C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_SNAC.log
C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_Support.log
C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_SCC.log
C

rogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_WI.log
And I donot see any significant error. Is there any round about for the installation In my cd , I have got the zip of the 2005 , I am unzipping it in the C:docandsettingsprogramfilesmicrosoftsqlserver.. and then running it.
Thanks

I got hold the following error in one of the log files: Error: Action "InstallToolsAction.10" threw an exception during execution. Error information reported during run: Target collection includes the local machine. Fatal Exception caught while installing package: "10" Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: sqlchainingsqlprereqpackagemutator.cpp Function Name: sqls:<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />qlPreReqPackageMutator::modifyRequest Source Line Number: 196 WinException caught while installing package. : 1603 Error Code: 0x80070643 (1603) Windows Error Text: Fatal error during installation. Source File Name: packageengineinstallpackageaction.cpp Function Name: sqls::InstallPackageAction:<img src=’/community/emoticons/emotion-4.gif’ alt=’

‘ />erform Source Line Number: 167 Trying to figure out , whats this error [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]

Now I am struck up with this error: Error code 2356 : Could not locate cabinet in stream : sql.cab How can I go about this. I have tried to google this error , but didnot find much information. Thanks

Hi, This may be because u r installing from local unzipped copy. In this case the installation folder shold have two folders.The first folder should be Named Servers, and the second should be named Tools.
http://support.microsoft.com/default.aspx/kb/907284 try in this way… Madhu

]]>