Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to change default mail port.

Author  Topic 

imranabdulaziz
Yak Posting Veteran

83 Posts

Posted - 2008-09-30 : 06:26:08
Hi all,
i am using sql server 2005.
i am using sp_sendmail for sending mail. but problem is antivirus is blocking port 25 . Is it possible to use other port for sending mail as client does not want to open port25 .
Any better solution Please suggest
Thank you.

NeilG
Aged Yak Warrior

530 Posts

Posted - 2008-09-30 : 06:55:50
Have you created a Database mail account in the SSMS under to Management folder, as you can change the port used when you edit the database mail profile
Go to Top of Page

imranabdulaziz
Yak Posting Veteran

83 Posts

Posted - 2008-09-30 : 06:57:35
i changed that port to 2525 but it failed to send the mail and getting this error

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2008-09-30T15:09:48). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it 212.0.16.135:2525).
Go to Top of Page
   

- Advertisement -