How to check whether Port 25 is open for DB Mail

Question

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

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Use telnet. Something like this:

[font="Courier New"]telnet MyMailServer 25[/font]

John

YTZ SSCommitted Points: 1707 More actions · Answer 2

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'

Cookies on SQLServerCentral