How to check whether Port 25 is open for DB Mail

  • 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?

  • Use telnet. Something like this:

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

    John

  • 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