Install a Configuration Manager 2012 R2 in a lab – 4. Install SQL Server 2012 SP1 (Powershell)

IT's magic!

I finished my experiment with unattended installation of SQL Server 2012. It was not that complicated I guessed but you cannot say it’s easy. So many setup switches…

What you have to do before starting the script I wrote (it’s at the end of this blog):

  • Copy the content of the SQL installation sources to disk
  • create an folder in this sources which is called “SQLUpdates” (you can name it different)
  • Copy the Service Pack 1 and the Hotfix KB2793634 into the folder created

Following the script/command line I wrote, start from the root of the source files folder:

.setup.exe /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS
/UpdateEnabled=1 /UpdateSource=.SQLUpdates
/features=”SQLEngine” “RS” “SSMS”
/installshareddir=”D:SQL(X64)”
/InstallsharedwowDir=”D:SQL(X86)”
/instancedir=”D:SQL(X64)”
/Instancename=MSSQLSERVER
/q
/AGTSVCACCOUNT=”NT AuthoritySystem”
/INSTALLSQLDATADIR=”D:SQL(X64)”
/SQLBACKUPDIR=”E:MSSQLSERVERBACKUP”
/SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS
/SQLSYSADMINACCOUNTS=”labordomain admins” “laboradministrator”
/SQLSVCACCOUNT=”NT AuthoritySystem”
/SQLTEMPDBDIR=”E:MSSQLSERVERTEMPDB”
/SQLTEMPDBLOGDIR=”E:MSSQLSERVERLOGS”
/SQLUSERDBDIR=”E:MSSQLSERVERUSERDB”
/SQLUSERDBLOGDIR=”E:MSSQLSERVERLogs”
/RSSVCACCOUNT=”NT AUTHORITYSYSTEM”
/INDICATEPROGRESS
/PID=”xxxxx-xxxxx-xxxxx-xxxxx-xxxxx”

Now I explain the different switches I used:

/ACTION=Install –> install SQL
/IACCEPTSQLSERVERLICENSETERMS –> to accept the license terms
/UpdateEnabled=1…

View original post 209 more words

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s