SQL Mail Problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Mail Problem

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-03-01 : 07:55:04

SenthilKumar writes "Hello,

I am facing a problem in SQL mail. I have a Installed MS Office 2000 Premium. I configured mailclient(Outlook 2000) with my Exchange server.

I have given the Same Profile used in my Mailclient to the Sql Server 2000.

After configuring this When i triggered xp_sendmail from the sql server to the Exchange server

address the sql server sent Mail correctly .

(example 1)
xp_sendmail 'Someid@exchangeserverdomain','Test'

But it not being triggering Any internet mails through the SQL SERVER 2000.When i am using

following.

(example 2)
xp_sendmail 'kppsenthil@yahoo.com','TestMail'

Other Details :

I have followed the below Topic from the Microsoft site to configure sql mail

"How to Use SQL Mail in Microsoft SQL Server 7.0 with Microsoft Outlook and Microsoft Exchange Server"

My Operating System is Windows 2000 Server - Service pack 3
Database : SQl server 2000
Exchange server : Microsoft Exchange 2000
Mail client : Microsoft Office 2000 Permium

Any one Please help out this.

-Senthilkumar K.P.P."

safigi
Starting Member

15 Posts

Posted - 2004-03-01 : 08:31:09

Hi,
When i worked as dba we have many problems with xp_sendmail. After that we used cdo.
There is a link for you:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q312839

Safi

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-03-01 : 13:03:11

So are you saying that you ran xp_sendmail and it did not return any errors but you never received the e-mail?

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources