Database mail using Exchange Server

Question

Database mail using Exchange Server

parth83.rawal

SSCommitted

Points: 1858
More actions
December 22, 2008 at 10:24 pm

#127630

Hi,
I am trying to send emails from SQL server,
Here i am using Exchange server and I dont have the SMTP,
while configuring the Profile with the SQL server i am facing problem as i have read some where that this SQL server's Database Mail is SMTP based Mailling Service, can anybody please elaborate that if i have Exchange Server how do i configure my Database Mail.
So if it is possible to Configure like wise. Please let me know and do throw some light over it.
Thanks in Advance
Parth

Viewing 15 posts - 1 through 14 (of 14 total)

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

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

Exchange is a SMTP based Mail Server. We use it with database mail at my job.

parth83.rawal SSCommitted Points: 1858 More actions · Answer 2

Hi,

i am using Sp_send_dbmail and i am succesfully sending it using SMTP.

now do you have any script of something using which i can use the Mail services or any online artical for this. or can you please provide me the configuration and all.

Please elaborate this more as i am in desperate need for this.

Thanks

Parth

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

do you have database mail configured correctly?

check BOL for more info

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

parth83.rawal SSCommitted Points: 1858 More actions · Answer 4

hi,

yes it is perfectly running when i am using as Servername where SMTP is configured but when it come to exchange Server, i am not able to send the mail,

Basically dont know how to Configure the Mail settings for the Exchange server , is it req. that i have to change the Exchange Server Settings...!!?

can you please elaborate this more ??

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

the sql server simply connects to exchange over port 25 and sends the mail!

from your sql server, telnet to port 25 on the exchange box, do you get a successful connection?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

parth83.rawal SSCommitted Points: 1858 More actions · Answer 6

Hi,

In Server Name : abc-smtp.xyz.com

Port Number : 2525

and Basic Authentication :

UserName : test@xyz.com

PassWord: ****

Password: ****

Above is working in case of SMTP Server While Using Exchange Server I am giving Following details and i am not able to send the Mail:

Server Name : mail.xyz.com

Port Number : 25

and Basic Authentication :

UserName : test@xyz.com

PassWord: ****

Password: ****

and above parameters giving me Error:

Please let me know if you know anything about it!!!

Thanks

Parth

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 7

parth83.rawal (12/24/2008)
Hi,
In Server Name : abc-smtp.xyz.com
Port Number : 2525
and Basic Authentication :
UserName : test@xyz.com
PassWord: ****
Password: ****
Above is working in case of SMTP Server While Using Exchange Server I am giving Following details and i am not able to send the Mail:
Server Name : mail.xyz.com
Port Number : 25
and Basic Authentication :
UserName : test@xyz.com
PassWord: ****
Password: ****
and above parameters giving me Error:
Please let me know if you know anything about it!!!
Thanks
Parth

What is the error that you get? Who manages the exchange server? Can they validate that mail.xyz.com is accepting connections on port 25? As the other person recommended, telnet to port 25 on that address and see if you get a connection.

parth83.rawal SSCommitted Points: 1858 More actions · Answer 8

Hi,

i dont know the setting was as it is i just change the port from 25 to 2525 ,

still for SMTP they are using 25 port only but some how mail was fired while using 2525

and i am done doing, still if i know more about this thing or you can elaborate more about this.

Thanks

Parth

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 9

If you can fire an email off on port 2525 then the mail server is using a non-standard port for SMTP. This isn't normal, but it isn't abnormal either. Just like we can set SQL Server to use a port other than 1433, the mail servers can be configured to use ports other than 25 for SMTP.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 10

port 2525 is usually used if blocking port 25.

Verify with the exchange admin the listener and outgoing ports?

Is the exchange server on the same network as the sql server?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

parth83.rawal SSCommitted Points: 1858 More actions · Answer 11

what i dont understand is that while configuring the outlook we have configure it to port 25 and while SQL we have to set it to 2525, what does this mean...!!?

Other thing i want to know is that while doing so is there any possibility that our mail has been stopped by the Firewall??????

because again that is big Que for me...!!!?

and yet we have not tested this on Production server. can you guide about this ,...!!?

Thanks and Merry X'mas

Parth

John V-423602 Grasshopper Points: 15 More actions · Answer 12

You also may need to make sure the server is in the allow smtp relay of your exchange server`s smtp connections properties. Its best to specify a static ip ad

dress if possible. Hope this helps, Merry X-Mas!

Perry Whittle SSC Guru Points: 234013 More actions · Answer 13

just be sure not to tick the "relay messages to all domains" check box otherwise after a couple of hours your public ip address will be blocked 😉

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

parth83.rawal SSCommitted Points: 1858 More actions · Answer 14

Hi,

now i am facing another problem regarding some GRAYLISTED. the Whole error message is as follows:

12/26/2008 11:02:05,,Error,85,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 11 (2008-12-26T11:02:05). Exception Message: Cannot send mails to mail server. (Error in processing. The server response was: Greylisted please try again in 837 seconds).

),6076,48,,12/26/2008 11:02:05 AM,sa

can anybody please throw some light on this please..........!!