February 8, 2002 at 8:59 am
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
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
http://www.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