balasach82
SSCrazy Eights
Points: 9653
More actions
August 31, 2010 at 7:32 am
#146815
How to check whether Port 25 is open/enabled for DB Mail. DB mail does not work.. need to know whether its because of SQL or because of Port 25 and firewall?
John Mitchell-245523
SSC Guru
Points: 148809
August 31, 2010 at 7:40 am
#1214289
Use telnet. Something like this:
[font="Courier New"]telnet MyMailServer 25[/font]
John
YTZ
SSCommitted
Points: 1707
August 31, 2010 at 8:18 am
#1214335
Suppose you have email profile name, please run this qurey under msdb:
select a.Name Mail_Profile_Name, s.port
from dbo.sysmail_account a INNER JOIN dbo.sysmail_server s ON a.account_id = s.account_id
WHERE a.Name ='Your Mail Profile Name'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply