Note: You can download SQL 2012 Developer edition if you are a MSDN subscriber
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
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
?
Comment by cqldba — December 22, 2011 @ 5:52 am |
as long as setup.exe is launched on remote machine with sufficient admin privileges, you can run automated installation.
To distribute software, you could also use http://www.microsoft.com/en-us/server-cloud/system-center/configuration-manager-overview.aspx
Comment by Sethu Srinivasan — January 3, 2012 @ 10:34 am |
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.
Comment by Andy Dring — January 5, 2012 @ 5:51 am |
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
Comment by Andy Dring — January 5, 2012 @ 5:57 am |