Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

SQL Server Reporting Services for Amazon RDS

Tags:

sql-server

amazon-ec2

amazon-rds

Recently, we have migrated a business application database to Amazon AWS SQL Server RDS. We have loved the flexibility of backup and scaling with the cloudified database, but we have need for writing reports for our gathered analytics data. Our in house data analyst is most comfortable using SQL Reporting Services. Normally, this is installed as a component with the SQL Server install, but we obviously do not have that option on RDS.

My question is, has anyone been able to successfully deploy and use SQL Reporting services with Amazon RDS?

What I have tried:

I attempted to spin up another EC2 instance, install "SQL Server Express with Advanced Services", and point SSRS to RDS, but it said that I had incompatible license types.

I plan on contacting the AWS team directly for this as well, but I thought that I would reach out to SO first to see if anyone has run into this. Thanks.

like image 591
feathj Avatar asked Jun 12 '12 13:06

feathj

People also ask

Does RDS support SSRS?

SSRS is a service built on top of SQL Server. You can use it to collect data from various data sources and present it in a way that's easily understandable and ready for analysis. Amazon RDS for SQL Server supports running SSRS directly on RDS DB instances. You can use SSRS with existing or new DB instances.

Is reporting services included with SQL Server?

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).

Does AWS RDS support SQL Server?

Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. With Amazon RDS, you can deploy multiple editions of SQL Server (2014, 2016, 2017 and 2019), including Express, Web, Standard, and Enterprise, in minutes with cost-efficient and re-sizable compute capacity.

Do I need a license for SQL Reporting Services?

In almost all cases, any of the SQL 'Services' components (reporting, notification, notification, etc) require the same license requirements as SQL Server (database) IF the SQL Server database is NOT concurrently installed on the same device.

1 Answers

You might need to use a certain Microsoft-created "Amazon Machine Image", specifically the "SQL Server Optimized" AMI: Microsoft AMIs.

like image 121
Russell Fox Avatar answered Oct 27 '22 01:10

Russell Fox
Sign in to Comment

Related questions

Why cookies expires when I restart SQL server?
Compiled query fails - Query was compiled for a different mapping source than the one associated with the specified DataContext
.NET SqlClient Error Number Enum Type
Relative Performance in SQLServer of Substring vs a Right-Left combo
Is assembly running in SQL Server or from a Windows app
Alternative to Report Viewer for SQL Reporting Services
SQL Server Impersonation and Connection Pooling
Node-SQL with node.js and MS integrated Security
Encryption with an AlwaysOn cluster
Entity Framework: how to find transaction isolation level in SQL Profiler?
SQLServer count() over() with distinct
Visual Studio 2015 debugger - high performance impact on SqlCommand
T-SQL stored procedure - Detecting if a parameter is supplied as OUTPUT
Unable to add performance counters of Oracle OLEDB provider
How do I make Entity Framework 6 (DB First) explicitly insert a Guid/UniqueIdentifier primary key?
Setting deadlock_priority does not make LOW priority session the victim
Unable to connect to remote SQL server from container
Capture the user who deleted the row in Temporal table
Considerations when dropping columns in large tables
Length of integer in SQL (i.e. length of decimal string)

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!