授予 Integration Services 服務的權限Grant Permissions to Integration Services Service

在舊版 [SQL Server]SQL Server中,當您安裝 [SQL Server]SQL Server 時,Users 群組中的所有使用者預設都能存取 Integration ServicesIntegration Services 服務。In previous versions of [SQL Server]SQL Server, by default when you installed [SQL Server]SQL Server all users in the Users group had access to the Integration ServicesIntegration Services service. 當您安裝目前版本的 [SQL Server]SQL Server時,使用者無法存取 Integration ServicesIntegration Services 服務。When you install the current release of [SQL Server]SQL Server, users do not have access to the Integration ServicesIntegration Services service. 因此,服務預設是安全的。The service is secure by default. 安裝 [SQL Server]SQL Server 之後,管理員必須授與該服務的存取權。After [SQL Server]SQL Server is installed, the administrator must grant access to the service.

授與 Integration Services 服務的存取權To grant access to the Integration Services service

  1. 執行 Dcomcnfg.exe。Run Dcomcnfg.exe. Dcomcnfg.exe 提供使用者介面,可供修改登錄中的某些設定。Dcomcnfg.exe provides a user interface for modifying certain settings in the registry.

  2. 在 [元件服務] 對話方塊中,展開 [元件服務] > [電腦] > [我的電腦] > [DCOM 組態] 節點。In the Component Services dialog, expand the Component Services > Computers > My Computer > DCOM Config node.

  3. 以滑鼠右鍵按一下Microsoft SQL Server Integration Services 12.0,然後按一下屬性Right-click Microsoft SQL Server Integration Services 12.0, and then click Properties.

  4. [安全性] 索引標籤上,按一下 [啟動和啟用權限] 區域中的 [編輯]On the Security tab, click Edit in the Launch and Activation Permissions area.

  5. 加入使用者並指派適當的權限,然後按一下 [確定]。Add users and assign appropriate permissions, and then click Ok.

  6. 重複步驟 4 - 5,以設定存取權限。Repeat steps 4 - 5 for Access Permissions.

  7. 啟動 SQL Server Management Studio。Restart SQL Server Management Studio.

  8. 重新啟動 Integration ServicesIntegration Services 服務。Restart the Integration ServicesIntegration Services Service.