Microsoft Teams and Skype for Business News and Thoughts

Tom Arbuthnot MVP
Tom Arbuthnot MCSM Communications

This site uses cookies

Find this blog useful? Please take a second to share, thanks!

Automated Script Install of SQL Server 2012

Published 26/08/2015 - 0 Comments

 

I often have to spin up labs for testing various Lync/Skype for Business setups, and have been meaning to work this out for a while. It turns out it’s pretty simple. The SQL installer has a command land switch to take a config file, from which you can specify all your install options.

With a bit of tweaking, here is my config file for a full install named INSTANCE1, with management tools, that adds server administrators as SQL Administrators. There are no references to any particular domain in the config file, so it should just work.

https://github.com/tomarbuthnot/Quiet-SQL2012AllFeaturesUnattendedInstall

 

image

The command line syntax is:

Setup.exe /ConfigurationFile=SQLConfigurationFile.ini

Note the forward slash, that threw me for a minute.

Here is how I use it in my lab

\\192.168.1.201\iso\SQL2012-SP2ISO\setup.exe /ConfigurationFile=”c:\PowerShell\SQL2012-Quiet-UTF8.ini”

 

There is a nice breakdown of the roles and their ini file feature name on this blog.

I know I’m a bit behind the times with SQL 2012, I’m sure I’ll jump up to 2014/2016 when I get time Smile . If you’ve beaten me to it, please let me know!

Tom Arbuthnot

Tom Arbuthnot

Principal Solutions Architect at Modality Systems
Tom Arbuthnot is Principal Solutions Architect at Unified Communications specialist Modality Systems. He is a Microsoft Certified Master and MVP, blogger, has a regular podcast with UCToday at tomtalks.show and is a regular speaker at events including Microsoft TechEd and Ignite. He co-runs The Microsoft UC User Group London.

No comments yet

Leave a Reply:


close

Weekly Email Update 
of all the key 
Microsoft Teams and Skype for Business News
every Tuesday

No Spam ever, I promise - Tom