none
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?

    Monday, December 23, 2013 3:50 PM

Answers

All replies