Saturday, September 27, 2014

0 Protocol is not supported for sending mails.

When I test the database mail function inside SQL Server, I get this error “Protocol is not supported for sending mails.” from dbo.sysmail_log.

select * from msdb.dbo.sysmail_log


The issue is when I created the database account, my use lower case smtp in the @mailserver_type.

When I change to the upper case ‘SMTP’. The issue is solved.


Post a Comment


SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates