SQL Server 組態管理員SQL Server Configuration Manager

[SQL Server]SQL Server 組態管理員是一個工具,用來管理 [SQL Server]SQL Server的相關服務、設定 [SQL Server]SQL Server所用的網路通訊協定,以及管理 [SQL Server]SQL Server 用戶端電腦的網路連接組態。 Configuration Manager is a tool to manage the services associated with [SQL Server]SQL Server, to configure the network protocols used by [SQL Server]SQL Server, and to manage the network connectivity configuration from [SQL Server]SQL Server client computers. [SQL Server]SQL Server 組態管理員是一個 MicrosoftMicrosoft Management Console 嵌入式管理單元,您可以從 [開始] 功能表存取它,也可以將它加入任何其他 MicrosoftMicrosoft Management Console 顯示畫面中。 Configuration Manager is a MicrosoftMicrosoft Management Console snap-in that is available from the Start menu, or can be added to any other MicrosoftMicrosoft Management Console display. MicrosoftMicrosoft Management Console (mmc.exe) 會在 Windows System32 資料夾中的 SQLServerManager10.msc 檔來開啟[SQL Server]SQL ServerConfiguration Manager。 Management Console (mmc.exe) uses the SQLServerManager10.msc file in the Windows System32 folder to open [SQL Server]SQL Server Configuration Manager.

[SQL Server]SQL Server 組態管理員和 SQL Server Management Studio 利用 Window Management Instrumentation (WMI) 來檢視和變更部份伺服器設定。 Configuration Manager and SQL Server Management Studio use Window Management Instrumentation (WMI) to view and change some server settings. WMI 提供統一的方式來協助您連結管理 [SQL Server]SQL Server 工具所要求之登錄作業的 API 呼叫,在 [SQL Server]SQL Server 組態管理員嵌入式管理單元元件的所選 SQL 服務上,它提供了增強的控制和操作功能。WMI provides a unified way for interfacing with the API calls that manage the registry operations requested by the [SQL Server]SQL Server tools and to provide enhanced control and manipulation over the selected SQL services of the [SQL Server]SQL Server Configuration Manager snap-in component. 如需設定 WMI 相關權限的相關資訊,請參閱設定 WMI 在 SQL Server 工具中顯示伺服器狀態For information about configuring permissions related to WMI, see Configure WMI to Show Server Status in SQL Server Tools.


因為 [SQL Server]SQL Server 組態管理員是 MicrosoftMicrosoft 管理主控台程式的嵌入式管理單元,而不是獨立的程式,所以 [SQL Server]SQL Server 組態管理員在較新版本的 Windows 中不會作為應用程式出現。Because [SQL Server]SQL Server Configuration Manager is a snap-in for the MicrosoftMicrosoft Management Console program and not a stand-alone program, [SQL Server]SQL Server Configuration Manager does not appear as an application in newer versions of Windows.

  • Windows 10Windows 10:
    若要開啟 [SQL Server]SQL Server Configuration Manager,請在起始頁,輸入 SQLServerManager12.msc (如SQL Server 2014SQL Server 2014)。To open [SQL Server]SQL Server Configuration Manager, on the Start Page, type SQLServerManager12.msc (for SQL Server 2014SQL Server 2014). 針對先前版本的[SQL Server]SQL Server以較小的數字取代 12。For previous versions of [SQL Server]SQL Server replace 12 with a smaller number. 按一下 SQLServerManager12.msc 開啟 Configuration Manager。Clicking SQLServerManager12.msc opens the Configuration Manager. 組態管理員釘選到起始頁或工作列,SQLServerManager12.msc,以滑鼠右鍵按一下,然後按一下開啟檔案位置To pin the Configuration Manager to the Start Page or Task Bar, right-click SQLServerManager12.msc, and then click Open file location. 在 Windows 檔案總管 中,SQLServerManager12.msc,以滑鼠右鍵按一下,然後按一下釘選到開始或是釘選到工作列In the Windows File Explorer, right-click SQLServerManager12.msc, and then click Pin to Start or Pin to taskbar.
    • Windows 8Windows 8:
      若要開啟 [SQL Server]SQL Server Configuration Manager,請在搜尋快速鍵應用程式,型別SQLServerManager<版本 >.msc例如SQLServerManager12.msc,然後按下EnterTo open [SQL Server]SQL Server Configuration Manager, in the Search charm, under Apps, type SQLServerManager<version>.msc such as SQLServerManager12.msc, and then press Enter.

若要利用 [SQL Server]SQL Server 組態管理員來啟動、停止、暫停、繼續或設定另一部電腦中的服務,請參閱連接至另一部電腦 (SQL Server 組態管理員)To start, stop, pause, resume, or configure services on another computer by using [SQL Server]SQL Server Configuration Manager, see Connect to Another Computer (SQL Server Configuration Manager).

管理服務Managing Services

請利用 [SQL Server]SQL Server 組態管理員來啟動、暫停、繼續或停止服務、檢視服務屬性,或變更服務屬性。Use [SQL Server]SQL Server Configuration Manager to start, pause, resume, or stop the services, to view service properties, or to change service properties.

使用 [SQL Server]SQL Server 組態管理員利用啟動參數來啟動 Database EngineDatabase EngineUse [SQL Server]SQL Server Configuration Manager to start the Database EngineDatabase Engine using startup parameters. 如需詳細資訊,請參閱設定伺服器啟動選項 (SQL Server 組態管理員)For more information, see Configure Server Startup Options (SQL Server Configuration Manager).

變更服務所用的帳戶Changing the Accounts Used by the Services

利用 [SQL Server]SQL Server 組態管理員來管理 [SQL Server]SQL Server 服務。Manage the [SQL Server]SQL Server services using [SQL Server]SQL Server Configuration Manager.


請一律利用 [SQL Server]SQL Server 工具 (如 [SQL Server]SQL Server 組態管理員) 來變更 [SQL Server]SQL Server[SQL Server]SQL Server Agent 服務所用的帳戶,或變更帳戶的密碼。Always use [SQL Server]SQL Server tools such as [SQL Server]SQL Server Configuration Manager to change the account used by the [SQL Server]SQL Server or [SQL Server]SQL Server Agent services, or to change the password for the account. 除了變更帳戶名稱之外, [SQL Server]SQL Server 組態管理員也會執行其他組態,例如,設定 Windows 登錄中的權限,使新的帳戶能夠讀取 [SQL Server]SQL Server 設定。In addition to changing the account name, [SQL Server]SQL Server Configuration Manager performs additional configuration such as setting permissions in the Windows Registry so that the new account can read the [SQL Server]SQL Server settings. 其他工具,例如 Windows 服務控制管理員,也能夠變更帳戶名稱,但無法變更相關設定。Other tools such as the Windows Services Control Manager can change the account name but do not change associated settings. 如果服務無法存取登錄的 [SQL Server]SQL Server 部份,服務可能無法適當啟動。If the service cannot access the [SQL Server]SQL Server portion of the registry the service may not start properly.

利用 [SQL Server]SQL Server 組態管理員、SMO 或 WMI 來變更密碼的另一個好處是,會立即生效,不需要重新啟動服務。As an additional benefit, passwords changed using [SQL Server]SQL Server Configuration Manager, SMO, or WMI take affect immediately without restarting the service.

管理伺服器和用戶端網路通訊協定Manage Server & Client Network Protocols

[SQL Server]SQL Server 組態管理員可讓您設定伺服器和用戶端網路通訊協定,以及連接選項。 Configuration Manager allows you to configure server and client network protocols, and connectivity options. 啟用正確的通訊協定之後,您通常不需要變更伺服器網路連接。After the correct protocols are enabled, you usually do not need to change the server network connections. 不過,如果您需要重新設定伺服器連接,您可以利用 [SQL Server]SQL Server 組態管理員,使 [SQL Server]SQL Server 利用特定的網路通訊協定、埠或管道來接聽。However, you can use [SQL Server]SQL Server Configuration Manager if you need to reconfigure the server connections so [SQL Server]SQL Server listens on a particular network protocol, port, or pipe. 如需啟用通訊協定的詳細資訊,請參閱 啟用或停用伺服器網路通訊協定For more information about enabling protocols, see Enable or Disable a Server Network Protocol. 如需啟用透過防火牆存取通訊協定的相關資訊,請參閱 設定 Windows 防火牆以允許 SQL Server 存取For information about enabling access to protocols through a firewall, see Configure the Windows Firewall to Allow SQL Server Access.

[SQL Server]SQL Server 組態管理員可讓您管理伺服器和用戶端網路通訊協定,其中包括強迫加密通訊協定、檢視別名屬性,或啟用/停用通訊協定的功能。 Configuration Manager allows you to manage server and client network protocols, including the ability to force protocol encryption, view alias properties, or enable/disable a protocol.

[SQL Server]SQL Server 組態管理員可讓您建立或移除別名、變更通訊協定的使用順序,或檢視伺服器別名的屬性,其中包括: Configuration Manager allows you to create or remove an alias, change the order in which protocols are uses, or view properties for a server alias, including:

  • 伺服器別名 — 用戶端連接之電腦所用的伺服器別名。Server Alias — The server alias used for the computer to which the client is connecting.

  • 通訊協定 — 組態項目所用的網路通訊協定。Protocol — The network protocol used for the configuration entry.

  • 連接參數 — 網路通訊協定組態之連接位址的相關參數。Connection Parameters — The parameters associated with the connection address for the network protocol configuration.

    另外, [SQL Server]SQL Server 組態管理員也可讓您檢視容錯移轉叢集執行個體的相關資訊,不過,部份啟動和停止服務之類的動作,應該使用叢集管理員。The [SQL Server]SQL Server Configuration Manager also allows you to view information about failover cluster instances, though Cluster Administrator should be used for some actions such as starting and stopping the services.

可用的網路通訊協定Available Network Protocols

[SQL Server]SQL Server 支援共用記憶體、TCP/IP 與具名管道通訊協定。 supports Shared Memory, TCP/IP, and Named Pipes protocols. 如需有關選擇網路通訊協定的詳細資訊,請參閱< Configure Client Protocols>。For information about choosing a network protocols, see Configure Client Protocols. [SQL Server]SQL Server 不支援 VIA、Banyan VINES Sequenced Packet Protocol (SPP)、多重通訊協定、AppleTalk 或 NWLink IPX/SPX 網路通訊協定。 does not support the VIA, Banyan VINES Sequenced Packet Protocol (SPP), Multiprotocol, AppleTalk, or NWLink IPX/SPX network protocols. 先前連接這些通訊協定的用戶端必須選取不同的通訊協定,才能連接到 [SQL Server]SQL ServerClients previously connecting with these protocols must select a different protocol to connect to [SQL Server]SQL Server. 您不能利用 [SQL Server]SQL Server 組態管理員來設定 WinSock Proxy。You cannot use [SQL Server]SQL Server Configuration Manager to configure the WinSock proxy. 若要設定 WinSock Proxy,請參閱您的 ISA 伺服器文件集。To configure the WinSock proxy, see your ISA Server documentation.

管理服務的如何主題 (SQL Server 組態管理員)Managing Services How-to Topics (SQL Server Configuration Manager)

啟動、停止、暫停、繼續、重新啟動 Database Engine、SQL Server Agent 或 SQL Server Browser 服務Start, Stop, Pause, Resume, Restart the Database Engine, SQL Server Agent, or SQL Server Browser Service

啟動、停止或暫停 SQL Server Agent 服務Start, Stop, or Pause the SQL Server Agent Service

將 SQL Server 執行個體設定為自動啟動 (SQL Server 組態管理員)Set an Instance of SQL Server to Start Automatically (SQL Server Configuration Manager)

避免自動啟動 SQL Server 的執行個體 (SQL Server 組態管理員)Prevent Automatic Startup of an Instance of SQL Server (SQL Server Configuration Manager)