Getting Error when try to connect sql server in RDS from SSRS in EC2

Question

Hello

I have running SSRS in EC2 and SQL server standard in RDS. I able to connect to rds using admin account from SSMS from EC2. But when i try configured the database in SSRS configuration part, I getting Error when running some scripts to create things in database (sorry i not familiar to sql).

I understand the admin user of RDS don't have fully control to grant some permission. I tried to create user and database first in SSMS and configure in manager and the another error showing the database is not sql server type.

Any idea how to fix these error? I feel like i looped on these same permission error. Or is not a good idea to host SSRS database in RDS?

Swe

Answer 1

Please post error message as text, not as a screenshot.

User does not have permission to perform this action.

As the error message already says.

SQL Server and Windows/AD have seperate security permissions, a Windows Admin is not automatically a SQL Server admin. You have to use an account with have the required SQL Server permissions.