Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
This link suggests that SQL Express doesn't support multiple instances: stackoverflow.com/questions/482408/… –  djangofan Jun 17 '10 at 19:31

2 Answers 2

if you run Setup interactively with the /FEATURES flag set, the installer will still give precedence to the command line parameters over what you select in the wizard.

Also - if an instance by the name of ABCD already exists on the server, you need to remove that instance before your script will work. You are telling it to install the database engine for instance ABCD, it is then checking and finding that the instance already has that feature installed.

share|improve this answer
    
Hi Brian. The instance name does not exist. –  Rubio May 5 '10 at 6:47

My understanding is that there can be an install config file that gets created after an initial command line attempt. Down in the Bootstrap or Bootstrap\log folder. Hope this helps.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.