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

x
?
Solved

Scripted or Push install of a SQL Server Express 2012 Instance

Posted on 2014-03-13
5
Medium Priority
?
457 Views
Last Modified: 2014-03-14
Is there a way either via a script or in group policy to automate or script an install of SQL Server Express 2012 for a given application?

I am trying to fully automate the process of deploying new machines in our network and one of our application installs needs an install of SQL Server Express 2012 as a prerequisite. I have not been able to find a way to do this.
0
Comment
Question by:Rob Sanders
  • 3
  • 2
5 Comments
 
LVL 25

Accepted Solution

by:
Mohammed Khawaja earned 2000 total points
ID: 39927716
I have done this in the past and I referred to MS document listed below:

http://msdn.microsoft.com/en-us/library/ms144259.aspx

Command below installs a new, stand-alone instance with the SQL Server Database Engine, Replication, and Full-Text Search components (as an example):

Setup.exe /q /ACTION=Install /FEATURES=SQL /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="<StrongPassword>" /SQLSYSADMINACCOUNTS="<DomainName\UserName>" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /IACCEPTSQLSERVERLICENSETERMS
0
 
LVL 1

Author Comment

by:Rob Sanders
ID: 39927734
thank you for the fast response. Does this work for SQL Express as well? Also, I need it to be an SQL Express instance for the specific application that I am installing (I don't know if this makes a difference or not.)
0
 
LVL 25

Expert Comment

by:Mohammed Khawaja
ID: 39927745
Should work fine but I haven't tried express version.  Try it out and let me know.
0
 
LVL 1

Author Comment

by:Rob Sanders
ID: 39930154
That worked. Thanks for the help.
0
 
LVL 25

Expert Comment

by:Mohammed Khawaja
ID: 39930253
Thanks for your quick response.  Glad to be of help and have a good day.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Viewers will learn how the fundamental information of how to create a table.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question