Thursday, June 16, 2011

Unattended installation of Microsoft SQL 2008 R2

Unattended installations can help administrators save time and efforts. Microsoft SQL 2008 R2 supports unattended installation method and this can be achieved by using switches which are supported by setup.

Use the following switches after "setup.exe" either from command prompt or may create a batch file in the same installation folder.

Setup.exe /qs /ACTION=Install /FEATURES=SQL,Tools /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS=".\Administrators"
/AGTSVCACCOUNT="NT AUTHORITY\Network Service" /IACCEPTSQLSERVERLICENSETERMS
 
Cheers,
Vijay
 

No comments: