ODBC SQLState HY000 Cannot generate SSPI context

  • El barto

    Ten Centuries

    Points: 1072

    Hello everyone,

    When running scheduled jobs from SQLAgent all jobs fail with the error message.

    [Microsoft SQL-DMO (ODBC SQLState: HY000)] Error 0: [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context

    There server has been rebooted, and I have confirmed connectivity to the box from various machines. The error still occurs when a) A new job is created b) When the user running the job is changed.

    Any advice?.

    Many thanks,


    Kindest Regards,

    Nick

  • Khwaja Arshaduddin

    SSC Eights!

    Points: 843

    This will help you.

    http://www.sqlservercentral.com/Forums/Topic10251-106-1.aspx

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

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