Configuring SQL Server Reporting Services for ASP.NET Running on Azure Web Role
•
1 like•1,815 views
This document discusses configuring SQL Server Reporting Services for an ASP.NET application running on an Azure web role. It covers creating a database on Azure Database, configuring SQL Server 2012 Reporting Services on an Azure VM, creating an ASP.NET report viewer, and deploying the ASP.NET application to an Azure web role. The presenter demonstrates each step and takes questions at the end.
Configuring SQL Server Reporting Services for ASP.NET Running on Azure Web Role
- 1. CONFIGURING SQL SERVER REPORTING SERVICES FOR ASP.NET RUNNING ON AZURE WEB ROLE ALLAN SPARTACUS MANGUNE MICROSOFT MVP FOR ASP.NET/IIS
- 2. AGENDA • Create a database on Azure Database • Configuring SQL Server 2012 Reporting Services on Azure Virtual Machine • Create an ASP.NET Report Viewer • Deploying ASP.NET App to Azure Web Role
- 3. CREATE DATABASE ON AZURE DATABASE • Microsoft Azure Portal • SQL Server Management Studio
- 4. DEMO
- 5. CONFIGURING SQL SERVER 2012 REPORTING SERVICES ON AZURE VIRTUAL MACHINE • Create a virtual machine • Use PowerShell to Create a Windows Azure VM With a Native Mode Report Server
- 7. USE POWERSHELL TO CREATE A WINDOWS AZURE VM WITH A NATIVE MODE REPORT SERVER
- 8. RUN THE REPORTS SERVER • Create an endpoint to port 80 or 443
- 9. DEMO
- 10. CREATE AN ASP.NET REPORT VIEWER • Network Credential Mapper • ReportViewer handler in the system.webserver with IntegratedMode pre- condition
- 11. DEPLOYMENT TO MICROSOFT AZURE • Set ReportViewer assemblies to copy to local bin folder • Microsoft.ReportViewer.WebForms.dll • Microsoft.ReportViewer.Common.dll
- 12. DEMO
- 13. Q & A
- 14. CONTACT ME • allanmangune@gmail.com • Facebook.com/mangune
- 15. THANK YOU!