遠端管理員連接伺服器組態選項remote admin connections Server Configuration Option

適用於: 是SQL Server 否Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

SQL ServerSQL Server 會提供專用管理員連接 (DAC)。provides a dedicated administrator connection (DAC). DAC 可讓系統管理員存取執行中的伺服器,如此一來,即使伺服器遭到鎖定或在異常狀態下執行,而且未回應 Transact-SQLTransact-SQL 連接時,也能執行診斷功能或 SQL Server Database EngineSQL Server Database Engine 陳述式,或針對伺服器上的問題進行疑難排解。The DAC lets an administrator access a running server to execute diagnostic functions or Transact-SQLTransact-SQL statements, or to troubleshoot problems on the server, even when the server is locked or running in an abnormal state and not responding to a SQL Server Database EngineSQL Server Database Engine connection. 依預設,只能從伺服器上的用戶端使用 DAC。By default, the DAC is only available from a client on the server. 若要讓遠端電腦上的用戶端應用程式使用 DAC,請使用 sp_configure 的 remote admin connections 選項。To enable client applications on remote computers to use the DAC, use the remote admin connections option of sp_configure.

根據預設,DAC 只會接聽回送 IP 位址 (127.0.0.1)、通訊埠 1434。By default, the DAC only listens on the loop-back IP address (127.0.0.1), port 1434. 如果無法使用 TCP 通訊埠 1434,當 Database EngineDatabase Engine 啟動時,會自動指派 TCP 通訊埠。If TCP port 1434 is not available, a TCP port is dynamically assigned when the Database EngineDatabase Engine starts up. 在電腦上安裝多個 SQL ServerSQL Server 執行個體時,請檢查錯誤記錄檔以取得 TCP 通訊埠編號。When more than one instance of SQL ServerSQL Server is installed on a computer, check the error log for the TCP port number.

下表列出 remote admin connections 選項的可能值。The following table lists the possible values for the remote admin connections option.

ReplTest1Value DescriptionDescription
00 表示只允許使用 DAC 的本機連接。Indicates only local connections are allowed by using the DAC.
11 表示允許使用 DAC 的遠端連接。Indicates remote connections are allowed by using the DAC.

範例Example

下列範例會從遠端電腦啟用 DAC。The following example enables the DAC from a remote computer.

sp_configure 'remote admin connections', 1;  
GO  
RECONFIGURE;  
GO  

另請參閱See Also

資料庫管理員的診斷連接Diagnostic Connection for Database Administrators