After changing 'MS SQL server' service's user name SDAC doesn't work properly

Question

I've changed 'MS SQL Server' service user name

from .\admin (have had such already) to network_services

and now my oracle linked servers to Oracle instance stopped to work.

Namely, 'Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server Ora_RO'.

In event log i see next:

The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID 
{2206CDB0-19C1-11D1-89E0-00C04FD7A829}
 and APPID 
{2206CDB0-19C1-11D1-89E0-00C04FD7A829}
 to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool.

So, MSDAINITIALIZE Class fails to start. I cannot locate this service under dcomcnfg. Could you help me?

Answer 1

The error seems to be clear what is causing the issue, check this link to fix this issue

Here the scenario is with SharePoint instead oracle so you can make out:-

http://www.wictorwilen.se/Post/Fix-the-SharePoint-DCOM-10016-error-on-Windows-Server-2008-R2.aspx

http://social.technet.microsoft.com/Forums/en-US/696204d5-b07e-46db-a785-737ea57b8da2/distributed-com-error-message

---

---

Mark ANSWER if this reply resolves your query, If helpful then VOTE HELPFUL
INSQLSERVER.COM Mohammad Nizamuddin

Answer 2

Hello,

This problem may occur if either of the following conditions is true: 

• A program with the class ID (CLSID) that appears in the message tries to start the COM component by using the DCOM infrastructure. However, the user does not have the required permissions to start the COM component.
• The Network Service account does not have the correct permissions.

Please refer to the followin KB article to solve this issue:
http://support.microsoft.com/kb/899965/en-us

Regards,  

---

Elvis Long
TechNet Community Support