SQL Mail in SQL 7.0

  • We have been trying to upgrade from 6.5 compatibility to 7.0 compatibility gradually and its causing some pain. There's a knowledgebase article about this that explained a lot.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;310822

    I tried to implement a wrapper around xp_sendmail, since we're not going to go to SQL authentication and linking to a non-clustered server just seemed risky in that we'd just go through another round if that server changed.

    I copied the stored procedure and made the necessary adjustments. It compiled fine, but is still giving me this error:

    Msg 17969, Level 16, State 1, Procedure , Line 0

    [Microsoft][ODBC SQL Server Driver][SQL Server]Unable to login to SQL Server.

    The mail client hasn't changed on that box. Where else can I troubleshoot?

    Regards

    Andre

  • I should also point out that I'm able to send mail through, but only if it doesn't have a @query=. Text messages seem to work okay.

    AndreQ

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

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