Installing a new SQL Server instance fails

Question

I've previously in my setup installed SQL Server Express 2005. Now I've switched to SQL Server Express 2008. I updated the command line parameters to those documented for the latter. If the comp already has SQL Server Express 2008 installed, my installer should create a new instance.

The command line parameters are as follows:

/ACTION=Install /FEATURES=SQLEngine /QS /INSTANCENAME=ABCD /SECURITYMODE=SQL /SAPWD=CunningPassword

The requested instance name does not exist on the target machine. This will end in an error -2068643838. The logs show the following error:

"No features were installed during the setup execution. The requested features may already be installed."

If I remove the /QS parameter and try to install interactively, I'll get as far as the Feature Selection page. The UI shows three options, Instance Features, Shared Features and Redistributable Features. Whatever I select, clicking Next results in the same error (There are validation errors on this page).

Any ideas anyone?

Thanks,

-- Rubio

Answer 1

I think it is related to the instancename in some way, when I changed from the default SQLExpress to a named on this error comes for me too. It is programming error in the way that I want to include the database installation bootstrapped from Wix in the setup.

Answer 2

I use this and its work.

/q /ACTION=Install /HIDECONSOLE /FEATURES=SQL /INSTANCENAME=ABCD /SECURITYMODE="SQL" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SAPWD="ABCD123456ab" /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /ENABLERANU=1 /AGTSVCACCOUNT="NT AUTHORITY\SYSTEM" /TCPENABLED=1 /ERRORREPORTING=1