使用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

 

转载于:https://www.cnblogs.com/maxhema/p/4646111.html