Solved

Scripted or Push install of a SQL Server Express 2012 Instance

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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

A hard and fast method for reducing Active Directory Administrators members.
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

623 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