Post reply

SQL AGENT JOBS ARE FAILING

  • May 16, 2013 at 3:57 am

    #277685

    Hi Team,

    I have problems with sql agent. Getting below error.

    SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but serviceaccount is not a member of the SysAdmin role)

    The agent use to work properly with same account. suddenly no job is running.

    I change it to other sql service account. Got the below error.

    Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]

    Changed the service account to Local it works. But I can not use it in prod.

    OS: Windows 2003

    SQL: 2008 R2 Enterprise.

    Please suggest.

  • May 16, 2013 at 4:43 am

    #1615691

    It's all here:

    http://msdn.microsoft.com/en-GB/library/ms191543.aspx

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

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

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