none
Event 10016

    Question

  • On a Windows 2008 R2 server running SQL Server 2012, I started getting these recently:

    SQL Server Scheduled Job 'Intraday Backup 1500.Subplan_1' (0x65C01B2C6FA5124493CA18E3665B09AA) - Status: Failed - Invoked on: 2012-09-10 16:18:58 - Message: The job failed.  Unable to determine if the owner (<DOMAIN>\administrator) of job Intraday Backup 1500.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user '<DOMAIN>\administrator', error code 0x6e. [SQLSTATE 42000] (Error 15404)).

    After some research it seemed that I should change the owner of the job to something else, so I made it SQLServerAgent, that seemed to be the only thing that worked.

    Now I'm getting these:

    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 NT SERVICE\SQLSERVERAGENT SID (S-1-5-80-355555556-2666666661-2777777773-2888888883-1999999990) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool.

    I did my usual digging around and couldn't find much that was useful, apart from notes about locating the appid mentioned in the registry and going to Component Services to fix the permissions.  The appid translates to MS DTS Server, nothing like that is listed in DCOM.



    I've done a fair bit of searching and reading and got nowhere with this, maybe I'm missing the point.  The job does run now, I'm just averse to errors in the Event Log, I mean they wouldn't be there if it didn't matter, would they?


    • Moved by Papy Normand Wednesday, September 19, 2012 3:07 PM related to the Database Engine (From:SQL Server Data Access)
    Monday, September 10, 2012 3:46 PM

Answers

  • Posted by iain27 on 3/10/2009 at 11:37 AM

    – open com permissions
        Component services, computers, my computer, 
    DCOM config, find the MSDTSServer100 
    Properties
        Security
        Launch and Activate permissions – edit
    Add the local SQL AgentUser group and enable local launch and Local activation

    I think translates to:

    Open Component Services, Computers, My Computer, DCOM Config, find Microsoft SQL Server Integration Services 11.0
    Properties
        Security
        Launch and Activate permissions – edit
    Add the local SQLServerAgent and enable Local Launch and Local Activation

    I'll let you know if it works.


    Fixed!  :)

    Wednesday, September 19, 2012 3:57 PM

All replies