介面區組態Surface Area Configuration

適用於: 是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預設組態中,許多功能都不會啟用。In the default configuration of new installations of SQL ServerSQL Server, many features are not enabled. SQL ServerSQL Server 為了將可能會遭受惡意使用者攻擊的功能數目最小化,因此會選擇性地只安裝與啟動主要的服務與功能。selectively installs and starts only key services and features, to minimize the number of features that can be attacked by a malicious user. 系統管理員可在安裝期間變更這些預設值,也可以選擇性地啟用或停用 SQL ServerSQL Server之執行中執行個體的功能。A system administrator can change these defaults at installation time and also selectively enable or disable features of a running instance of SQL ServerSQL Server. 此外,從其他電腦連接時,某些元件可能要等到設定通訊協定之後才能使用。Additionally, some components may not be available when connecting from other computers until protocols are configured.

注意

與新安裝不同的是,在升級處理期間不會關閉任何現有的服務或功能,但是在升級完成後可能會套用其他介面區組態選項。Unlike new installations, no existing services or features are turned off during an upgrade, but additional surface area configuration options can be applied after the upgrade is completed.

通訊協定、連接和啟動選項Protocols, Connection, and Startup Options

您可以使用 SQL ServerSQL Server 組態管理員來啟動和停止服務、設定啟動選項,以及啟用通訊協定和其他連線選項。Use SQL ServerSQL Server Configuration Manager to start and stop services, configure the startup options, and enable protocols and other connection options.

啟動 SQL Server 組態管理員To start SQL Server Configuration Manager

  1. 指向 [開始] 功能表上的 [所有程式] ,然後依序指向 [ Microsoft SQL ServerMicrosoft SQL Server] 和 [組態工具] ,再按一下 [SQL Server 組態管理員]On the Start menu, point to All Programs, point to Microsoft SQL ServerMicrosoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager.

    • 使用 SQL Server 服務 區域來啟動元件並設定自動啟動選項。Use the SQL Server Services area to start components and configure the automatic starting options.

    • 使用 SQL Server 網路組態 區域來啟用連線通訊協定,以及連線選項,例如固定 TCP/IP 通訊埠或強制加密。Use the SQL Server Network Configuration area to enable connection protocols, and connection options such as fixed TCP/IP ports, or forcing encryption.

如需詳細資訊,請參閱 SQL Server 組態管理員For more information, see SQL Server Configuration Manager. 遠端連接可能也會取決於防火牆的正確組態。Remote connectivity can also depend upon the correct configuration of a firewall. 如需詳細資訊,請參閱 設定 Windows 防火牆以允許 SQL Server 存取For more information, see Configure the Windows Firewall to Allow SQL Server Access.

啟用和停用功能Enabling and Disabling Features

您可以使用 SQL ServerSQL Server 中的 Facet 來設定啟用和停用 SQL Server Management StudioSQL Server Management Studio功能。Enabling and disabling SQL ServerSQL Server features can be configured using facets in SQL Server Management StudioSQL Server Management Studio.

使用 Facet 來設定介面區To configure surface area using facets

  1. Management StudioManagement Studio 中,連接至 SQL ServerSQL Server 的元件。In Management StudioManagement Studio connect to a component of SQL ServerSQL Server.

  2. 在 [物件總管] 中,以滑鼠右鍵按一下伺服器,然後按一下 [Facets] 。In Object Explorer, right-click the server, and then click Facets.

  3. 在 [檢視 Facets] 對話方塊中,展開 [Facet] 清單,並選取適當的 [介面區組態] Facet ([介面區組態] 、[Analysis Services 的介面區組態] ,或 [Reporting Services 介面區組態] )。In the View Facets dialog box, expand the Facet list, and select the appropriate Surface Area Configuration facet (Surface Area Configuration, Surface Area Configuration for Analysis Services, or Surface Area Configuration for Reporting Services).

  4. Facet 屬性區域中,選取您想要用於每個屬性的值。In the Facet properties area, select the values that you want for each property.

  5. 按一下 [確定] 。Click OK.

若要定期檢查 Facet 的組態,請使用以原則為基礎的管理。To periodically check the configuration of a facet, use Policy-Based Management. 如需原則式管理的詳細資訊,請參閱 使用原則式管理來管理伺服器For more information about Policy-Based Management, see Administer Servers by Using Policy-Based Management.

您也可以使用 sp_configure 預存程序來設定 Database EngineDatabase Engine 選項。You can also set Database EngineDatabase Engine options using the sp_configure stored procedure. 如需詳細資訊,請參閱 伺服器設定選項 (SQL Server)伺服器組態選項。For more information, see Server Configuration Options (SQL Server).

變更 SSRSSSRSEnableIntegrated Security 屬性時,請使用 SQL Server Management StudioSQL Server Management Studio 中的屬性設定。To change the EnableIntegrated Security property of SSRSSSRS, use the property settings in SQL Server Management StudioSQL Server Management Studio. 若要變更 [排程事件和報表傳遞] 屬性以及 [Web 服務和 HTTP 存取] 屬性時,請編輯 RSReportServer.config 組態檔。To change the Schedule events and report delivery property and the Web service and HTTP access property, edit the RSReportServer.config configuration file.

命令提示字元選項Command-prompt Options

您可以使用 Invoke-PolicyEvaluationSQL ServerSQL Server PowerShell Cmdlet 以叫用介面區組態原則。Use the Invoke-PolicyEvaluationSQL ServerSQL Server PowerShell cmdlet to invoke Surface Area Configuration Policies. 如需詳細資訊,請參閱 使用 Database Engine CmdletFor more information, see Use the Database Engine cmdlets.

SOAP 和 Service Broker 端點SOAP and Service Broker Endpoints

若要關閉端點,請使用以原則為基礎的管理。To turn endpoints off, use Policy-Based Management. 建立和改變端點的屬性時,請使用 CREATE ENDPOINT (Transact-SQL)ALTER ENDPOINT (Transact-SQL)To create and alter the properties of endpoints, use CREATE ENDPOINT (Transact-SQL) and ALTER ENDPOINT (Transact-SQL).

SQL Server Database Engine 和 Azure SQL Database 的資訊安全中心Security Center for SQL Server Database Engine and Azure SQL Database

sp_configure (Transact-SQL)sp_configure (Transact-SQL)