Tom Talks Microsoft Teams and Microsoft 365 Collaboration news and opinions

Automated Script Install of SQL Server 2012

 

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!

About the author

Tom Arbuthnot

A Microsoft MVP and Microsoft Certified Master, Tom Arbuthnot is Principal Solutions Architect at Microsoft Collaboration specialists Modality Systems.

Tom stays up to date with industry developments and shares news and his opinions on his blog, Microsoft Teams Podcast and email list. He is a regular speaker at events around the world.

Add comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Tom Talks Microsoft Teams and Microsoft 365 Collaboration news and opinions