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

image

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.

0 comments:

Post a Comment

 

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