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.
0 comments:
Post a Comment