Lukket

AWS SQL Setup

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.

Evner: Amazon Web Services, Linux, MySQL, Database Administration, Microsoft SQL Server

Se mere: developing web based applications access, problem primavera sql setup, setup telemarketing company, developing web based crm, company name field entourage, setup project company name, forum php outsource company developing sms system, setup change company name, sql setup service provider, sql setup mediawiki, developing flash based applications j2ee, developing http based chat, sql server script insert xml field, setup project company, lock excel field based time day, my client a young fintech company in dublin 2 are now looking to hire an experienced ms sql developer on a permanent basis with

Om arbejdsgiveren:
( 7 bedømmelser ) London, United Kingdom

Projekt ID: #30928737

4 freelancere byder i gennemsnit £31 timen for dette job

skanusha504

hi, We will face these issues while executing openrowset functions. I have experience in resolving these kind of issues while working as database administrator. Please initiate chat to discuss further.

£50 GBP in 2 dage
(4 bedømmelser)
4.7
iarc13th

Hi, I can help with the error you're facing. We need to update DB configurations. Feel free to get in touch :)

£20 GBP på 1 dag
(6 bedømmelser)
2.5
badal747

###SQL server hosting expert in AWS### Hi I have seen your error and want to ready to work. I have experience in SQL server hosted on any cloud server like AWS. I seen the error message during database restore from loc Flere

£40 GBP på 1 dag
(5 bedømmelser)
2.1
GolpikCorp

Hi, this is Azlan from Golpik. I have thoroughly reviewed your requirement and I am confident that we can work on your project and submit you with the deliverables in the promised time. However, I have a few questions Flere

£15 GBP in 7 dage
(0 bedømmelser)
0.0