How to check whether Port 25 is open for DB Mail

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » How to check whether Port 25 is open for DB...

How to check whether Port 25 is open for DB Mail

Rate Topic

Display Mode

Topic Options

Author

Message

balasach82

Posted Tuesday, August 31, 2010 7:32 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:55 AM
Points: 307, Visits: 743

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?

Post #977967

John Mitchell-245523

Posted Tuesday, August 31, 2010 7:40 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:44 AM
Points: 4,434, Visits: 7,218

Use telnet. Something like this:

telnet MyMailServer 25

John

Post #977985

YTZ

Posted Tuesday, August 31, 2010 8:18 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 12:48 PM
Points: 57, Visits: 3,261

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'

Post #978036

« Prev Topic | Next Topic »

Permissions