Click here to Skip to main content
12,348,594 members (57,900 online)
Rate this:
 
Please Sign up or sign in to vote.
I have been trying to write the right command line for installing SQL Sever 2008 R2 Express version 4 days and I have read all related posts on this website as well as other website. I also have read the "How to: Install SQL Server 2008 R2 from the Command Prompt" on MSDN. But none of them works.

Now here is my arguments(exclude setup.exe).

/qs /ACTION=Install /FEATURES=SQL /INSTANCENAME=MSSQLSERVER /ADDCURRENTUSERASSQLADMIN=True /IACCEPTSQLSERVERLICENSETERMS

Problem :By using it, the SQL installer can show up and proceed until the Installation Process and closes without any errors popping up.

I have used all my ideas to find out what's wrong in my command line.

Please help me to write the right command line for SQL Server 2008 R2 installation.

Thank you!!!
Posted 7-May-13 13:38pm
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

"SQL Server 2008 Unattended Install"[^]

Frankly, I never include a SQL Server install in my app installers. It's up to the user to have a SQL Server installation already running. They just need to supply the server name, username and password to get at it.
  Permalink  
Comments
franva008 8-May-13 0:26am
   
Hi Dave, thank you for your reply.
In my case, the users want to minimize their work, so I have to include pretty much everything for them. What they need to do is to double click the installer and it will check the pre-requisite software and install our own software after that.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

I finally got it right.

Here is the command line I use and it works.

/qs /ACTION=Install /FEATURES=SQLEngine,SSMS /INSTANCENAME="Your instance name here" /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSYSADMINACCOUNTS="Administrators" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /IACCEPTSQLSERVERLICENSETERMS


You can also change other accounts, but the accounts you are going to use must have been created in your system and it is better an admin account and you do not need to specify the password.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 7 May 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100