Issue with Configuring SSRS on EC2 with RDS

Hello,

I am currently working on setting up SQL Server Reporting Services (SSRS) on an Amazon RDS instance with an EC2 instance acting as the application client. Specifically, I want to store SSRS metadata in Amazon RDS while using the EC2 instance to manage SSRS. However, I'm facing an issue related to permissions when trying to configure SSRS Manager.

Microsoft.Data.SqlClient.SglException (0x80131904): User does not have permission to perform this action. at Microsoft.Data.Sq/Client.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action' 1 wrapCloseInAction) at Microsoft.Data.Sq/Client.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClos>) | at Microsoft. Data.Sq/Client. TdsParser. TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) | at Microsoft.Data.SqlClient.SglCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at Microsoft.Data.SqlClient.SalCommand.InternalExecuteNonQuery(TaskCompletionSource* 1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asynWrite, Boolean inRetry) at Microsoft.Data.SalClient.SalCommand.ExecuteNonQuery0 at Microsoft.ReportingServices. Common.DBUtils. ApplyScript(Sq|Connection conn, String script, [CommandWrapperFactory commandWrapper) at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script) at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script) ClientConnectionid:bb8025ab-64f9-4da 1-bedd-609ef63cb0e9 Error Number: 15247 State: 1, Class: 16

My current setup:

Amazon RDS for SQL Server is being used to store SSRS metadata.

• The EC2 instance is configured as the application client for SSRS.

My questions:

Is it possible to store SSRS metadata in an RDS instance while using an EC2 client for SSRS, considering RDS's limitations on user permissions?

I understand this is some permission error cannot do in RDS admin role. but i checking here, is there anyone using this kind of set up before?

Thanks
Swe