xp_sendmail: Cannot generate SSPI context

• john645

  Valued Member

  Points: 55

  More actions

  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

• Steven.

  SSCrazy Eights

  Points: 9806

  More actions

  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

• john645

  Valued Member

  Points: 55

  More actions

  November 21, 2003 at 9:35 am

  #483151

  Hello Steven,

  I am running Service Pack 3.

  The account used for sqlmail is sysadmin

• K. Brian Kelley

  SSC Guru

  Points: 114562

  More actions

  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

• john645

  Valued Member

  Points: 55

  More actions

  November 24, 2003 at 9:32 am

  #483397

  It is failing on all queries