Post reply

Help wanted

  • February 8, 2002 at 8:59 am

    #57754

    Hi EveryBody

    I'm trying to send email from SQL Server to an email recipeint.

    But whenever i try to execute following statement in Query Analyzer ...

    USE master

    EXEC xp_startmail

    exec Xp_sendmail 'mack2002@hotmail.com', 'Hello'

    exec xp_stopmail

    Then i get following error...

    SQL Mail session started.

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

    xp_startmail: failed with mail error 0x80040605

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

    xp_sendmail: failed with mail error 0x80004005

    Stopped SQL Mail session.

    Configuration is following

    SQL Server 2000

    Outlook Client 2000

    Lotus Notes Email Server

    Plz guide me.

    Thnx in advance.

    Mack

  • February 8, 2002 at 9:05 am

    #423527

    First, have you created a profile in Outlook and verified you have the ability to send and receive? Is it configured as a POP3 server? This is outside of SQL Server.

    Then, if the Profile works, have you setup SQLMail to use it?

    Here's a Knowledge Base article link that talks about some of the setup issues with non-Exchange servers:

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

    A quote from inside the document reads as follows:

    quote:

    Microsoft does not support using SQL Mail to communicate with mail servers such as Lotus Notes, Lotus cc:Mail, or Novell GroupWise unless they are treated as POP3 servers.

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://qa.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

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

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