Solved

Scripted or Push install of a SQL Server Express 2012 Instance

Posted on 2014-03-13
5
440 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article explains the steps required to use the default Photos screensaver to display branding/corporate images
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

751 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