Solved

Scripted or Push install of a SQL Server Express 2012 Instance

Posted on 2014-03-13
5
428 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 500 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

On some Windows 7 (SP1) computers, Windows Update becomes super slow even the computer is reasonably fast.  There's one solution that seemed to have worked well for me (after trying a few other suggested solutions).
This script can help you clean up your user profile database by comparing profiles to Active Directory users in a particular OU, and removing the profiles that don't match.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now