Post reply

xp_sendmail: Cannot generate SSPI context

  • November 20, 2003 at 4:01 pm

    #83563

    Hello All,

    I am having the following problem:

    When using xp_sendmail along with a query I get this error:

    Server: Msg 17969, Level 16, State 1, Line 0

    xp_sendmail: Unable to login to SQL Server.

    ODBC error 0 (HY000) Cannot generate SSPI context

    However, when using xp_sendmail just to send an email without a query it works just fine. No errors, no problems!

    This problem just started happening. For the year prior to this, the stored procedure that used xp_sendmail ran just fine.

    Any ideas would be appreciated!

    Thanks

  • November 21, 2003 at 7:00 am

    #483075

    Does the account you are using to run this query under have permissions to access the objects in the query?

    Also what sql version and service pack are you on.

    Steven

  • November 21, 2003 at 9:35 am

    #483151

    Hello Steven,

    I am running Service Pack 3.

    The account used for sqlmail is sysadmin

  • November 21, 2003 at 2:12 pm

    #483232

    Are you failing on a particular query or is it for all queries?

    K. Brian Kelley, GSEC

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • November 24, 2003 at 9:32 am

    #483397

    It is failing on all queries

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

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