I was recently doing some testing of a script I created for a client which used SQL Database Mail for sending emails. this was on my one of my demo environments, but I received an error when testing the script:
![Error message](https://i0.wp.com/365community.online/wp-content/uploads/2022/03/Error-Sending-Mail-Using-SQL-Database-Mail.png?w=838&ssl=1)
Microsoft Dynamics GP
Unhandled database exception:
[Microsoft][SQL Server Native Client 11.0][SQL Server]The EXECUTE permission was denied on the object...
Continue Reading azurecurve’s Article on their blog
Error Sending Mail Using SQL Database Mail
I was recently doing some testing of a script I created for a client which used SQL Database Mail for sending emails. this was on my one of my demo environments, but I received an error when testing the script: Microsoft Dynamics GP Unhandled database exception: [Microsoft][SQL Server Native Client 11.0][SQL Server]The EXECUTE permission was denied on the object ‘sp_send_dbmail’, database ‘msdb’, schema ‘dbo’.
Blog Syndicated with azurecurve’s Permission
More About This Author
Array
Dyn365GP26 July 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Enable Sustainability Features for Integrations with APIs
Dyn365GP26 July 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Manage Subscription Billing and Revenue and Expense Recognition
Dyn365GP25 July 2024New Functionality In Microsoft Power Automate 2024 Wave 1: Scale Faster with Power Automate Process Mining Thin Client App
Dyn365GP25 July 2024New Functionality In Microsoft Power Automate 2024 Wave 1: Use the New Desktop Flow Running Timeout Property