Since this is my first year entering the PowerShell Scripting Games, I’m only submitting scripts for the beginner events but I’m also taking a look at the advanced ones to get an idea of what kind of knowledge is needed for them. It’s not too late to join in on the fun. Make sure you read the requirements of each event carefully, create your script, test it, and think about it for a while before submitting it.
I’m installing a line of business application that requires the SQL Server Management Studio and Client Tools Connectivity be installed as a prerequisite. I want to script this instead of having to manually click through the GUI for the installation since this will be installed on several servers. I’ve mounted the SQL Server 2008 R2 ISO on “Z” drive. The following command will produce the desired results: Setup.exe /qs /ACTION=Install /FEATURES=SSMS,CONN /IACCEPTSQLSERVERLICENSETERMS At first, I thought that the CONN parameter was incorrect because it also added the SQL Client Connectivity SDK, but upon further review the GUI installation does the same thing: