Share via

reporting services on prem connected to azure sql

ares 206 Reputation points
2022-09-15T16:30:30.44+00:00

Can I connect from an azure reporting service server to an azure sql or azure sql managed instances?

any issue I should be aware of?

thanks

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,491 Reputation points
    2022-09-16T09:21:10.82+00:00

    Hi @ares ,

    Do you mean that you want to connect to Azure sql server database in SSRS report or you want to set the Azure sql server database as the report server database?

    If you want to connect to Azure sql database as data source, you may refer to sql-azure-connection-type-ssrs.

    An example here: creating-an-ssrs-report-from-an-azure-sql-database.

    If you mean the latter one, SSRS does not support Azure SQL DB for its Catalog and Temp DBs.

    You may try the workaround mentioned here.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.