SQL Server Universal Instalation Scripts
Presentation link: http://sqlfeatures.com/2015/09/17/305/
Supported configurations:
Infrastructure Amazon AWS EC2 Windows Azure VMware Hyper-V Physical servers
OS Versions Windows 2008 R2 Windows 2012 Windows 2012 R2
SQL Version SQL Server 2008 R2 SQL Server 2012 SQL Server 2014
SQL Editions Standard Enterprise Developer
Any combination of SQL server service pack and cumulative updates with Hot fixes
Pre-Requisite: VM configuration ••W2012/R2 standard•E drive with 50GB (install sql here) •F drive 20GB (Filestream, optional to create if product required) •UAC disabled •Update patches •Added to domain •Grant PowerShell unrestricted and bypass execution rights •Disable automatic patch update
SQL Server installation steps
Note: User account which initiate installation should be local admin for standalone installations, domain admin for Cluster and AlwaysON configuration 1.Run powershell as administrator 2.Execute below command
Command: powershell \InstallSQL.ps1 Parameter 1: #sqlfeatures\svcSQLfeatures Parameter 2: #qqqEqq1! <<Minimum 8 digit toupgh password>> Parameter 3: #SAtemp2014 Parameter 4: #AMD_2015 Parameter 5: #sqlfeatures\sqldba (group responsible for support) Example: \\Scripts\InstallSQL\InstallSQL.ps1 sqlfeatures\svcSQLfeatures Tester1! SAtemp2014 SQL_2008_STD sqlfeatures\sqldba