Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Install SQL Server 2012 with command line
1.安裝SQL Server之前,必須先安裝.Net Framework 3.5.1。
可以透過Server Manager或PowerShell的方式來安裝。
(1)使用Server Manager安裝。
(2)使用PowerShell安裝。
A.以系統管理員身分啟動PowerShell命令提示字元。
B.輸入以下命令。
Import-Module ServerManager
Add-WindowsFeature NET-Framework-Core
How to install/enable .Net 3.5 SP1 on Windows Server 2008 R2 for SQL Server 2008 and SQL Server 2008 R2
Overview of Server Manager Commands
https://technet.microsoft.com/en-us/library/cc732757.aspx
2.放入SQL Server 2012安裝光碟。
3.以系統管理員身份啟動命令提示字元,執行以下命令。
以下範例光碟機為E:,以下命令只安裝SQL Server Database Engine(包含SQLEngine,Replication,FullText),Integration Service與完整Tools
E:\>setup.exe /q /ACTION=Install /FEATURES=SQL,IS,Tools /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="CONTOSO\SQLServer" /SQLSVCPASSWORD="P@ssw0rd" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSYSADMINACCOUNTS="CONTOSO\Administrator" /IACCEPTSQLSERVERLICENSETERMS /PID "ABCDE-FGHIJ-KLMNO-PQRST-UVWXY"
依照不同的需求與環境需要修改的參數如下:
/FEATURES
SQL表示安裝完整的Database Engine(包含SQLEngine,Replication,FullText)
IS表示Integration Service
Tools表示完整工具
/SQLSVCACCOUNT="CONTOSO\SQLServer" 指定SQL Server啟動帳戶
/SQLSVCPASSWORD="CONTOSO\SQLServer" 指定SQL Server啟動帳戶的密碼
/AGTSVCACCOUNT="NT AUTHORITY\Network Service 指定SQL Server Agent啟動帳戶,SQL Agent指定的是系統帳戶,則不需要指定/AGTSVCPASSWORD
/PID "ABCDE-FGHIJ-KLMNO-PQRST-UVWXY" 指定產品金鑰
/SQLSYSADMINACCOUNTS 指定要加入SQL Server系統管理員的Windows帳戶,此帳戶會被授予sysadmin roles。
有關啟動帳戶,可以指定以下帳戶:
(1)本機帳戶,例如MySQLServer\SQLServiceAccount
(2)網域帳戶,例如CONTOSO\SQLServiceAccount
(3)系統帳戶,例如NT AUTHORITY\NETWORK SERVICE,NT AUTHORITY\LOCAL SERVICE
(4)本機虛擬帳戶(受管理的本機帳戶),Windows 7 和 Windows Server 2008 R2 中提供的新帳戶類型
例如
NT Service\MSSQLSERVER
NT Service\SQLSERVERAGENT
NT Service\MSSQLServerOLAPService
NT Service\MsDtsServer110
NT Service\ReportServer
有關FEATURES請參考下面連結的FEATURES參數
Install SQL Server 2012 from the Command Prompt
https://msdn.microsoft.com/en-us/library/ms144259.aspx
4.安裝程式執行完成後,可能會出現必須重新啟動伺服器的訊息,如下圖,請重新開機。
5.由以上的範例安裝完成後,開始功能表與SQL Server服務如下:
SQL Server Configuration Manager只有以下服務:
SQL Server Integration Services 10.0
SQL Full-Text Filter Daemon Launcher (MSSQLSERVER)
SQL Server (MSSQLSERVER)
SQL Server Browser
SQL Server Agent (MSSQLSERVER)
6.若要完整安裝,啟動帳戶指定預設虛擬帳戶,則執行以下命令。
E:\>setup.exe /q /ACTION=Install /FEATURES=SQL,AS,RS,IS,DQC,MDS,Tools /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="NT Service\MSSQLSERVER" /AGTSVCACCOUNT="NT Service\SQLSERVERAGENT" /ASSVCACCOUNT="NT Service\MSSQLServerOLAPService" /RSSVCACCOUNT="NT Service\ReportServer" /SQLSYSADMINACCOUNTS="CONTOSO\Administrator" /ASSYSADMINACCOUNTS="CONTOSO\Administrator" /IACCEPTSQLSERVERLICENSETERMS /PID="ABCDE-FGHIJ-KLMNO-PQRST-UVWXY"
SQL Server Configuration Manager全部的SQL Server服務:
SQL Server Integration Services 10.0
SQL Full-Text Filter Daemon Launcher (MSSQLSERVER)
SQL Server (MSSQLSERVER)
SQL Server Analysis Services (MSSQLSERVER)
SQL Server Reporting Services (MSSQLSERVER)
SQL Server Browser
SQL Server Agent (MSSQLSERVER)
[Reference]
Install SQL Server 2012 from the Command Prompt
https://msdn.microsoft.com/en-us/library/ms144259.aspx