Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 508
  • Last Modified:

command line install sql express 2008 r2 with tools

I'm trying to install SQL Express 2008 R2 doing a command line install.  I'm currently using following parameters:

 /Q /HIDECONSOLE /INSTANCENAME=SQLEXPRESS /FEATURES=TOOLS /SECURITYMODE=SQL /SAPWD=mypassword  /IACCEPTSQLSERVERLICENSETERMS

When I run the install the it will hang up and give me an error.  I'm trying to install SQL Server Express along with Management Studio using quite mode.
0
PeterTrefren
Asked:
PeterTrefren
  • 3
  • 2
1 Solution
 
AmmarRCommented:
this is another link about unattended installation

https://blogesh.wordpress.com/2008/09/23/silent-install-of-sql-server-2008/
0
 
PeterTrefrenAuthor Commented:
After a fair amount of trail and error I ended up using the following parameters:

/qs /ACTION=Install /FEATURES=SQL,Tools /SECURITYMODE=SQL /SAPWD="mypassword" /INSTANCENAME=SQLEXPRESS /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /IACCEPTSQLSERVERLICENSETERMS

I didn't seem to have a lot of success installing Tools by itself but at this point I'm happy with the fact it works.  
0
 
AmmarRCommented:
its good to hear that.

i guess now you can keep it in a batch file or you also have the option if a configuration file for sql setup

http://msdn.microsoft.com/en-us/library/dd239405(v=SQL.100).aspx

All the best
0
 
PeterTrefrenAuthor Commented:
This solution will give a generic install of SQlL Server.  However just realize it does not allow remote connections.  If you are looking to have other computers access this instance of SQL server you wiill have to use the additional parameters.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now