email from sqlserver with msdb

[gonzalogomez]

Hi there.

After migrating to 10.0 FP2208.

I have modified the transaction notification so that it uses the msdb to send emails from the sql server data mail.

This is in the msdb database and uses a stored procedure called sp_send_mail.

The specific error is this.

[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'. ‘GL company information’ (CINF) (CINF)

It is an issue of execution permissions from the SAP SQL database to the MSDB, but I cannot determine which one or how.

Someone knows?

[S_Sriram]

Hi Gomez

Check this SCN thread it may help you fix the issue

https://answers.sap.com/questions/11842925/the-execute-permission-was-denied-on-the-object--i.html

Regards

SS

[gonzalogomez]

The post says it is resolved, but not how... oh my god.

I have already tried all kinds of permissions to the new database user of version 10.0, but I cannot get it to execute that stored procedure of the msdb database