locked
SQL Agent Jobs Fails RRS feed

  • Question

  • Hi All,

    The job failed.  Unable to determine if the owner (BI\Dev) of job FirstDataCreditCardCBC has server access (reason: Could not obtain information about Windows NT group/user 'BI\Dev', error code 0x5. [SQLSTATE 42000] (Error 15404)).

    I have done the changes in the SQL server configuration manger eventhough the job has failed.

    Thanks

    Thiru

    Monday, January 14, 2013 11:53 PM

Answers

  • Check if the job owner has access to this server and the SQL instance to run the job.

    Try changing to the owner of the job to SA and run the job

    • Proposed as answer by Kumar muppa Tuesday, January 15, 2013 5:22 AM
    • Marked as answer by Allen Li - MSFT Monday, January 21, 2013 2:27 AM
    Tuesday, January 15, 2013 12:16 AM

All replies