xp_sendmail error: Cannot generate SSPI context

From: John P. (anonymous_at_discussions.microsoft.com)
Date: 11/20/03 

Date: Thu, 20 Nov 2003 14:52:25 -0800

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

Relevant Pages

  • RE: Web query problem when password required
    ... Madhan, ... The problem with login is solved but the problem with query is not yet ... .WebDisableDateRecognition = False ...
    (microsoft.public.excel.programming)
  • Query on SQL Server 2000 Linked Table Doesnt Provide Correct Results
    ... I have some backend tables in a SQL Server 2000 Database linked into ... If I run the same query in query analyzer, ... User daemon value rlogin is true ... User bin value login is true ...
    (microsoft.public.access.queries)
  • Re: Query on SQL Server 2000 Linked Table Doesnt Provide Correct Results
    ... You may be able to use Lenin a calculated query field to determine if the count of characters is not what you expect. ... I have some backend tables in a SQL Server 2000 Database linked into ... User daemon value rlogin is true ... User bin value login is true ...
    (microsoft.public.access.queries)
  • Re: Permissions WTF
    ... What does the following query return for your windows ... Jasper Smith (SQL Server MVP) ... > the login does not have explicit access to any db's and no server roles ...
    (microsoft.public.sqlserver.security)
  • RE: constructing a http request using LWP..
    ... but i have to do this on linux. ... With this you don't have to worry about constructing the query string. ... is it possible to automate the login and log out say from yahoo mail ...
    (perl.beginners)