Post reply

Unable to execute a job in SQLServer Agent

  • November 23, 2006 at 5:21 am

    #115367

    Hai

    Iam puzzled to see that till yesterday i was able to create a job and execute it successfully through SQLServer Agent. Today i created a new job  and scheduled it to run. But the job is failing to run, and generating error as

    Unable to start execution of step 1 (reason: Error authenticating proxy AST\nmn, system error: Logon failure: unknown user name or bad password.).  The step failed.

    I don't know the reason why it is suddenly not running.If anybody experienced such problem, pls reply me.

    Thanks

    Nirmala

     

     

  • November 25, 2006 at 11:42 am

    #673907

    The first guess is that the new job is doing something different such as trying to access server resources that the proxy account doesn't have access to or accessing another server remotely without proper access.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • November 27, 2006 at 11:35 pm

    #674228

    Check proxy account settings and privledges.

    Pankaj Khanna
    Database Administrator - SQL Server 2000

    Keep hope to keep you intact...

  • November 28, 2006 at 10:02 am

    #674452

    Someone changed the account/

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply