Solved

Scripted or Push install of a SQL Server Express 2012 Instance

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

Accepted Solution

by:
Mohammed Khawaja earned 500 total points
Comment Utility
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
Comment Utility
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 24

Expert Comment

by:Mohammed Khawaja
Comment Utility
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
Comment Utility
That worked. Thanks for the help.
0
 
LVL 24

Expert Comment

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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
sql query 7 34
VBS Script not working correctly. 1 16
Files in temp directory 16 34
windows 7 password recovery tools 3 19
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup". After a while, you have entered a loop for Auto repair which does not fix anything and you will be in a  panic as all your work w…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
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.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

743 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

17 Experts available now in Live!

Get 1:1 Help Now