SQL Server Performance Forum – Threads Archive
Error – Installing client tools – SQL Server 2005Hello 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…
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
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
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:
Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_Core(Local).log
Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_Datastore.xml
Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_.NET Framework 2.0.log
Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_Core.log
Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_.NET Framework 2.0 LangPack.log
Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_.NET Framework Upgrade Advisor.log
Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_.NET Framework Upgrade Advisor LangPack.log
Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_.NET Framework Windows Installer.log
Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_.NET Framework Windows Installer LangPack.log
Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_SNAC.log
Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_Support.log
Crogram FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0027_DEPAUL-EF4AE0A7_SCC.log
Crogram 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.
I got hold the following error in one of the log files:<br /><br />Error: Action "InstallToolsAction.10" threw an exception during execution. Error information reported during run:<br /><br />Target collection includes the local machine.<br /><br />Fatal Exception caught while installing package: "10"<br /><br />Error Code: 0x80070002 (2)<br /><br />Windows Error Text: The system cannot find the file specified.<br /><br />Source File Name: sqlchainingsqlprereqpackagemutator.cpp<br /><br /><br />Function Name: sqls:<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />qlPreReqPackageMutator::modifyRequest<br /><br />Source Line Number: 196<br /><br /><br />WinException caught while installing package. : 1603<br /><br />Error Code: 0x80070643 (1603)<br /><br />Windows Error Text: Fatal error during installation.<br /><br />Source File Name: packageengineinstallpackageaction.cpp<br /><br /><br />Function Name: sqls::InstallPackageAction:<img src=’/community/emoticons/emotion-4.gif’ alt=’‘ />erform<br /><br />Source Line Number: 167<br /><br /><br />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