使用SSMS 2012某些功能在Windows2012 環境報錯解決

標籤：

引用於http://www.sqlcn.com/post/29.html

在Windows Server 2012 + SQL Server 2012環境中，使用SSMS經常會報錯如下：

 

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID 

{FDC3723D-1588-4BA3-92D4-42C430735D7D}

 and APPID 

{83B33982-693D-4824-B42E-7196AE61BB05}

 to the user mydomain\myname SID (S-1-5-21-1144337295-3700848864-1050654588-5830) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.

 

 

解決方案：

 

1. Click Start -> Run -> Type -> dcomcnfg, expand Component Services -> Computers -> My Computer -> DCOM Config.
2. Click View -> Detail -> Now you will get Application Name and Application ID in right side.
3. Scroll down and find the application ID {AD65A69D-3831-40D7-9629-9B0B50A93843} -> Right Click -> Properties and select the Security tab.
3. Click Customize under "Launch & Activation Permission" -> click Edit -> Add in the account NT AUTHORITY\SYSTEM and set local launch and local activation.
4. Restart the application Service linked to this Application ID or restart the server and monitor

 

 

問題解決。

 

 

 

原創文章，轉載請保留www.sqlcn.com。本文地址：www.sqlcn.com/post/29.html sqlcn.N

 

使用SSMS 2012某些功能在Windows2012 環境報錯解決