Click here to Skip to main content
Rate this: bad
good
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 at 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
0 OriginalGriff 210
1 Richard MacCutchan 100
2 kbrandwijk 90
3 ProgramFOX 80
4 Sandeep Singh Shekhawat 70
0 Sergey Alexandrovich Kryukov 9,050
1 OriginalGriff 8,151
2 CPallini 2,613
3 Richard MacCutchan 2,221
4 Abhinav S 1,928


Advertise | Privacy | Mobile
Web03 | 2.8.140827.1 | Last Updated 7 May 2013
Copyright © CodeProject, 1999-2014
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