Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Fail to create a new instance

Author  Topic  itziks Starting Member 3 Posts Posted - 2010-08-20 : 08:48:16 hi guys, I have a machine with sql express sp3 installed on it. I am trying to create a new instance (call it tst_inst) using a command line: sqlexpr32.exe -q /norebootchk reboot=ReallySuppress ADDLOCAL=SQL_Engine INSTANCENAME=tst_inst SQLAUTOSTART=1 SECURITYMODE=SQL SAPWD=some_pass i get the following error message in the event viewer: Product: Microsoft SQL Server 2005 Express Edition -- A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component. when i do set the upgrade property like this: sqlexpr32.exe -q /norebootchk reboot=ReallySuppress UPGRADE=SQL_Engine ADDLOCAL=SQL_Engine INSTANCENAME=tst_inst SQLAUTOSTART=1 SECURITYMODE=SQL SAPWD=some_pass i get the following error message in the event viewer: Product: Microsoft SQL Server 2005 Express Edition -- Error 28011. SQL Server Setup cannot perform the upgrade because the component is not installed on the computer. To proceed, verify that the component to be upgraded is currently installed, and that the component to be upgraded is specified in the ADDLOCAL property. For more information, see Running Setup from the Command Prompt in SQL Server Books Online. An important note: it does not happen if the installed sql express is sp2 or less, only on sp3... What does it want from me...?