Home Forums SQL Server 2005 Administering How to check whether Port 25 is open for DB Mail RE: How to check whether Port 25 is open for DB Mail
YTZ
SSCommitted
Points: 1707
More actions
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'