SQL Server Performance

How to fix failed job

Discussion in 'General DBA Questions' started by kolanv, Apr 26, 2007.

  1. kolanv New Member

    Hi,<br /><br /> There are few jobs on the server which are failing continously and they through following error messages as below.<br /><br />1)Executed as user: NT AUTHORITYSYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.<br /> <br />2)Executed as user: vanivani_aps. OLE DB provider 'MSDAORA' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed. <br /><br />3)Unable to connect to SQL Server '(local)'. The step failed<br /><br />4)Unable to perform a SETUSER to the requested username 'dbo' because the username is invalid for database 'ABCDEF'. The step failed.<br /> <br />5)The job failed. Unable to determine if the owner (VANIvani_aps) of job Getting DB Details has server access (reason: Could not obtain information about Windows NT group/user 'vanivani_aps'. [SQLSTATE 42000] (Error 819<img src='/community/emoticons/emotion-11.gif' alt='8)' />). <br /> <br /><br /><br /><br /><br /><br /><br /><br /><br /><br />vanishree
  2. ghemant Moderator

    Hi,
    Have you check the report file of the Job? What does this job do?

    Hemantgiri S. Goswami
    MS SQL Server MVP
    -------------------------
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

    http://hemantgirisgoswami.blogspot.com
  3. kolanv New Member

    Hi,

    Yes the report file of the job is checked. Its a database backup job using database maintenance plan which is scheduled.
    Every time it throws the error

    Executed as user: NT AUTHORITYSYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.


    and another job is throwing error as

    Executed as user: dbo. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed



    Thanks & Regards
    Vani

    vanishree
  4. ghemant Moderator

  5. Chappy New Member

  6. MohammedU New Member

    By any chance did you guys removed builtin adminitrator accout on this server?


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  7. sharp_92 New Member

    I am getting one of the same messages you had listed. I'm unable to figure out how to get this fixed. Did you ever get any feedback for the following?
    4)Unable to perform a SETUSER to the requested username 'dbo' because the username is invalid for database 'ABCDEF'. The step failed.
    The particular user that keeps defaulting here has been removed from our Network/SQL system completely. I have tried several things but can't seem to get anything to work. HELP!!
    Thanks
  8. satya Moderator

    Have you changed the job to execute under SQL SErver service account in thsi case?
  9. sharp_92 New Member

    Not sure exactly what you are asking me here. I am new to SQL2005, and training classes keep getting canceled. I’m learning by trial and error….and reading. Under the SQL Server Configuration Manager I have changed the following to
    SQL Server running w/log on as = ADSQLAdminSQL Server Analysis Services running w/logon as = ADSQLAdminSQL Server Agent running w/logon as = ADSQLAdmin Originally they were set to the departed user that the SETUSER is attempting to use.
  10. satya Moderator

    In this case please open a new question and post in relevant forum sections only.
    follow up in SQL 2005 general DBA section.

Share This Page