Possible to host SQL server 2022 in AWS RDS as SSRS database?

Question

Possible to host SQL server 2022 in AWS RDS as SSRS database?

Swe 25

Hello,

I would like to know is that possible to host SSRS database sql server 2022 in AWS RDS? I trying to host SSRS in EC2 and SQL server in RDS then I use rds admin user to connect database on Configuration manager set up and getting this permission error.

Is that due to RDS is AWS managed service and cannot grant to full permission on user? User's image

Thanks Swe

Olaf Helper 47,631 Reputation points

2025-03-19T08:50:52.46+00:00

The screenshot is much to small to see anything, please post the error message as text.
Swe 25 Reputation points

2025-03-20T01:08:23.26+00:00

Sorry, my client is blocking to copy paste things out. I can try to take another image in clear.

srose-3539 0

I have the same problem when running SQL Server in RDS and SSRS on a separate server. Here's some more information:

Connecting SSRS to the database using the sa account almost finishes, the but when "Running database script" it fails because sa doesn't actually have full permissions on RDS SQL Server.

ssrs-install

Microsoft.Data.SqlClient.SqlException (0x80131904): User does not have permission to perform this action.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource
 
`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(SqlConnection conn, String script, ICommandWrapperFactory commandWrapper)
   at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
   at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
ClientConnectionId:eb81da4e-9151-467b-b7ec-625a22f50b39
Error Number:15247,State:1,Class:16

I can't install SSRS on RDS because it only works if you also also have Active Directory connected. I can't use an account with higher permissions because SQL Server on RDS makes it impossible to give an account the sysadmin permission.

So is there a way to connect SSRS (hosted elsewhere) to SQL Server that's running in RDS?

2 answers

Your answer

Olaf Helper 47,631 Reputation points

2025-03-19T08:50:52.46+00:00

The screenshot is much to small to see anything, please post the error message as text.
Swe 25 Reputation points

2025-03-20T01:08:23.26+00:00

Sorry, my client is blocking to copy paste things out. I can try to take another image in clear.

Answer 1

madhu tiwari 0

AWS RDS for SQL Server does not support hosting SQL Server Reporting Services (SSRS). AWS RDS supports SQL Server databases but does not include SSRS, SQL Server Integration Services (SSIS), or SQL Server Analysis Services (SSAS).

However, you can still use SSRS with SQL Server on AWS by adopting one of the following approaches:

EC2 Instances:

Deploy SQL Server with SSRS on an EC2 instance.
You have full control over the environment, allowing you to install and configure SSRS.
Connect the SSRS instance on EC2 to the RDS SQL Server database as the data source.

Hybrid Setup:

Use AWS RDS for SQL Server as the database.
Host SSRS on an EC2 instance and connect it to the RDS instance.
This approach reduces the maintenance overhead of managing the SQL Server database directly on EC2.

AWS Native Reporting Alternatives:

Consider using AWS-native services like AWS QuickSight for reporting and data visualization.
QuickSight can connect to SQL Server RDS and other data sources.

Containers:

Host SSRS using Docker containers on AWS ECS or EKS.
Use RDS as the backend database.AWS RDS for SQL Server does not support hosting SQL Server Reporting Services (SSRS). AWS RDS supports SQL Server databases but does not include SSRS, SQL Server Integration Services (SSIS), or SQL Server Analysis Services (SSAS). However, you can still use SSRS with SQL Server on AWS by adopting one of the following approaches: 1. EC2 Instances:
- Deploy SQL Server with SSRS on an EC2 instance.
- You have full control over the environment, allowing you to install and configure SSRS.
- Connect the SSRS instance on EC2 to the RDS SQL Server database as the data source.
2. Hybrid Setup:
- Use AWS RDS for SQL Server as the database.
- Host SSRS on an EC2 instance and connect it to the RDS instance.
- This approach reduces the maintenance overhead of managing the SQL Server database directly on EC2.
3. AWS Native Reporting Alternatives:
- Consider using AWS-native services like AWS QuickSight for reporting and data visualization.
- QuickSight can connect to SQL Server RDS and other data sources.
4. Containers:
- Host SSRS using Docker containers on AWS ECS or EKS.
- Use RDS as the backend database.

Swe 25 Reputation points

2025-03-20T00:59:11.14+00:00

Hello yes, currently i am using like that, SSRS in ec2 and sql server in RDS. however seems i cannot grant the permission from admin to my ssrs user and getting that error.
Anonymous

2025-12-03T07:41:30.41+00:00
Hi Madhu i have similar setup as you mentioned here,

2. Hybrid Setup:

Use AWS RDS for SQL Server as the database.

Host SSRS on an EC2 instance and connect it to the RDS instance.

This approach reduces the maintenance overhead of managing the SQL Server database directly on EC2.

but i m getting same error when adding database in ssrs configuration manager,
i have given dbowner permission to report server and report server temp db but it does not help i guess it need sysadmin user atleast to function which is not possible on rds if i m right?

or if you can help me please how this hybrid setup will work as you mentioned above?
srose-3539 0 Reputation points

2025-12-29T15:15:31.4266667+00:00
Not helpful.

RDS does support SSRS (you turn on an option group) but that's not what the question asker is doing. They have SQL Server in RDS, and SSRS in EC2.

Maybe this would work, but redeploying the whole database on EC2 instead of RDS is a big change.

This is what the question asker is trying to do, but running into an error. Have you done this and gotten it to work? There are now 3 people (Swe, Shahzeena, and me) who have chimed in to say we're doing this and it doesn't work.

This misses the point of the question even more than #1.

This is basically the same principle as #2, and would run into the same problem.

I suspect this answer is AI slop, copied in from an LLM.
Swe 25 Reputation points

2025-12-30T01:54:34.9233333+00:00

@srose-3539 yea I understand how you struggle. We ended up hosting reportserver database in Custom RDS Sql server (which is same as installing own sql in ec2) but custom is hybrid so AWS will handle some parts.

We need rsexecution role which is not enough with sa to able to connect the databse from configuration manager. That role is only can do with hosted sql not native rds by AWS.

So we used custom rds as database tier and application is installed in EC2 which is app tier due to our destign limitation.

Hope this can help u.
Anonymous

2026-01-02T07:00:11.9666667+00:00

Hi Guys thanks for clarifying, Option Group SSRS, RDS with MSSQL engine nothing helps only MSSQL on EC2 instance and SSRS also on EC2 instance works cause thats how we have full control with SA role to generate DSN when connecting MSSQL with SSRS, and unfortunately the official document of AWS does not clearly mention our situation rather they try to enforce us to use Option Group which is also not helpful they didnt mention that as well.
I dont know to be honest what actually we can do with SSRS option group when we are not able to connect a DB engine with it, such senseless Integration option given to users.

Answer 2

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

2 deleted comments

Comments have been turned off. Learn more