Using SSRS with Azure SQL

%3CLINGO-SUB%20id%3D%22lingo-sub-1776291%22%20slang%3D%22en-US%22%3EUsing%20SSRS%20with%20Azure%20SQL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1776291%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20several%20hundred%20SSRS%20reports%20that%20have%20a%20parameterized%20connection%20string%20allowing%20the%20server%20and%20database%20to%20be%20selected%20by%20passing%20parameters.%20I%20moved%20the%20300%20or%20so%20databases%20that%20use%20these%20reports%20to%20AZURE%20SQL%20in%20an%20elastic%20pool.%20What%20does%20Microsoft%20offer%20to%20host%20my%20RDL%20files%20in%20Azure%3F%20Does%20the%20fee%20I%20pay%20for%20the%20Azure%20Databases%20cover%20a%20license%20to%20run%20SSRS%20like%20having%20the%20deployment%20onsite%20does%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1776347%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20SSRS%20with%20Azure%20SQL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1776347%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F196780%22%20target%3D%22_blank%22%3E%40Bill%20Walter%3C%2FA%3E%26nbsp%3BYou%20can%20host%20database%20catalog%20used%20for%20SSRS%20in%20an%20Azure%20Managed%20Instance%20that's%20hosted%20on%20Azure%20VM%20that%20is%20separate%20DB%20engine%20implementation%20and%20licensing%20that%20what%20you%20currently%20have.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Visitor

I have several hundred SSRS reports that have a parameterized connection string allowing the server and database to be selected by passing parameters. I moved the 300 or so databases that use these reports to AZURE SQL in an elastic pool. What does Microsoft offer to host my RDL files in Azure? Does the fee I pay for the Azure Databases cover a license to run SSRS like having the deployment onsite does?

 

1 Reply

@Bill Walter You can host database catalog used for SSRS in an Azure Managed Instance that's hosted on Azure VM that is separate DB engine implementation and licensing that what you currently have.