We are a Fintech company and are developing field-based investor financier matching. We have developed a SQL Server database to implement this automated matching process and successfully run it locally. We now hope to deploy this database on AWS. We tried AWS RDS but found that the key procedure could not be executed correctly. The error Message is like:
Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 1 [Batch Start Line 2]
The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 1 [Batch Start Line 2]
The EXECUTE permission was denied on the object 'sp_OAMethod', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 1 [Batch Start Line 2]
The EXECUTE permission was denied on the object 'sp_OAMethod', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 1 [Batch Start Line 2]
The EXECUTE permission was denied on the object 'sp_OAMethod', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 1 [Batch Start Line 2]
The EXECUTE permission was denied on the object 'sp_OAMethod', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 1 [Batch Start Line 2]
The EXECUTE permission was denied on the object 'sp_OAMethod', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sp_OAGetProperty, Line 1 [Batch Start Line 2]
The EXECUTE permission was denied on the object 'sp_OAGetProperty', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sp_OAGetProperty, Line 1 [Batch Start Line 2]
The EXECUTE permission was denied on the object 'sp_OAGetProperty', database 'mssqlsystemresource', schema 'sys'.
Msg 229, Level 14, State 5, Procedure sp_OAGetProperty, Line 1 [Batch Start Line 2]
The EXECUTE permission was denied on the object 'sp_OAGetProperty', database 'mssqlsystemresource', schema 'sys'.
(1 row affected)
Completion time: 2021-07-21T13:58:06.9982599+01:00
Our clients(financier) data and investor data are stored in two different Pipedrive account. We use Integromat to listen to the Pipedrive deals. When a new deal added, Integromat will add a row to a table in SQL Server and trigger the SQL Server stored procedure. The stored procedure will use API to get the deal info from Pipedrive and make a matching. The matching result will be uploaded to Pipedrive and use Database mail send to the deal owner for notification.
We hope you can help us solve this problem, or you can use EC2 to deploy this database and test it.