SQL Server 2012 Unattended installation


Note: You can download  SQL 2012 Developer edition if you are a MSDN subscriber

https://msdn.microsoft.com/en-us/subscriptions/securedownloads/hh442898#searchTerm=&ProductFamilyId=461&Languages=en&PageSize=50&PageIndex=0

OR

Download SQL 2012 Evaluation:
1) To download evaluation edition Goto Download
for x86, Download  following files to local folder on your machine

ENU\x86\SQLFULL_x86_ENU_Core.box

ENU\x86\SQLFULL_x86_ENU_Install.exe

ENU\x86\SQLFULL_x86_ENU_Lang.box

2) Open command window, extract downladed files to local folder

CD c:\SQL2012\

SQLFULL_x86_ENU_Install.exe

You will see extracted files under C:\SQL2012\SQLFULL_x86_ENU

 

 

Installation:
1) Open Command window as Elevated Administrator
2) CD C:\SQL2012\SQLFULL_x86_ENU

Unattended setup command line

Setup /QS
/ACTION=install
/INSTANCEID="SQL2012EVAL"
/INSTANCENAME="MSSQLSERVER"
/IACCEPTSQLSERVERLICENSETERMS=1
/FEATURES=SQL,Tools
/SQLSYSADMINACCOUNTS="machine-name\Administrators"
/BROWSERSVCSTARTUPTYPE=AUTOMATIC
/SECURITYMODE=SQL
/SAPWD="Password#1234$"
/INDICATEPROGRESS
/TCPENABLED=1
/AGTSVCSTARTUPTYPE="Automatic"

Above command does the following
- Installs SQL Server & Management tools
- Grants SQL sysadmin privilege for localgroup “Administrators”
- Enables TCP protocol for SQL instance
- Autostarts SQL Browser service
- Autostarts SQL Server Agent

5) Wait for setup.exe to complete

About these ads

Developer @ SQL Server Team, Microsoft

Posted in SQL Server
4 comments on “SQL Server 2012 Unattended installation
  1. cqldba says:

    is it possible to perform remote install using powershell?
    Eg: I have source server where all my setup.exe and i will run a vbscript or automated processs (using powershell) which will install sql 2012 on remote serevr is it possible
    ?

  2. Andy Dring says:

    You could use Invoke-Command with the Setup command as the scriptblock, ie invoke-command -computername -scriptblock {set-location C:\SQL2012\SQLFULL_x64_ENU;Setup /QS /ACTION=install …}. If you preceded that command with $creds = get-credential and entered the appropriate username and password in the dialog box, you can use different credentials too, just add to the PS command. That should do it.

  3. Andy Dring says:

    Some of my comment got removed, possibly because I used the greater-than and less-than symbols. The PS command should have included “-computername server_name” before the scriptblock, and the last section should have read “just add -credential $creds to the PS command”.

    should also have noted, this requires PS v2, but if you’re installing SQL2012, you’re using 2008 R2 anyway, so shouldn’t be a problem. Just remember to configure remoting properly

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: