Protocol is not supported for sending mails.

Saturday, September 27, 2014

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.

SQL Panda