In this article:
Looking for information about related technologies? See:
When you add SQL Azure Reporting to your SQL Azure subscription, a report server is automatically provisioned for your account. After the report server is available, you can do the following:
For sample code for each of these scenarios, see SQL Azure Reporting Samples.
Return to Top
Microsoft SQL Azure Reporting Preview provides features similar to on-premise SQL Server 2008 R2 Reporting Services configured in native mode.
For the list of differences between the platforms, see Guidelines and Limitations.
See Getting Started with SQL Azure Reporting.
Login to the SQL Azure Reporting portal by using the report server URL and either the report server administrator credentials or a the credentials provided by your administrator. Navigate the folder structure to the report, and click on the report.
For more information, see Getting Started with SQL Azure Reporting for Report Readers.
Alternatively, create a Windows Azure Web role or worker role application that points to the hosted report.
For more information, see Getting Started with SQL Azure Reporting for Application Developers.
When you add SQL Azure Reporting to your existing SQL Azure subscription, you will get the URL to the report server, the report server administrator user name. You specify the password. Use these report server administrator credentials to:
The report server URL is the Web Service URL with /reportserver appended. You must use the https protocol to access the report server. For example, if your Web Service URL is abcdefgh.database.windows.net, the report server URL is https://abcdefgh.database.windows.net/reportserver.
For a summary of when to use which credentials, see Getting Started Guides for SQL Azure Reporting.
For troubleshooting common connectivity problems to SQL Azure, see the SQL Azure Connectivity Troubleshooting Guide.
For troubleshooting reports and report servers, see SQL Azure Reporting Troubleshooting .
Only the SQL Azure report data source type is supported. A typical connection string looks like this:
Data Source=<server>.database.windows.net;Initial Catalog=<database>; Encrypt=True; TrustServerCertificate=False
You must get database login credentials (user name and password) from the database administrator. By design, credentials are not included in the connection string.
For more information, see Troubleshooting Tips in SQL Azure Reporting Troubleshooting.
For more information about working with database administrators who manage the data that you want to use in your report, see Getting Started with SQL Azure Reporting for Database Administrators.
Use a report authoring client tool to publish reports to your SQL Azure Reporting report server. You can also upload reports, one at a time.
For a list of tools, see Tool Compatibility.
For a list of which credentials to use, see Credential Summary.
Yes.
From a report published on a SQL Azure Reporting report server, data sources and data source credentials are stored on the report server. Access to databases hosted on SQL Azure require only the connection string and login credentials that you received from the database administrator.
To preview reports on a client tool, the database administrator must add your client IP address to the firewall exception list for the database.
For more information about working with database administrators who manage the data behind your report, see Getting Started with SQL Azure Reporting for Database Administrators.
When you add SQL Azure Reporting to your SQL Azure subscription, the service provisions one report server. To provision more report servers, create additional SQL Azure subscriptions in your Windows Azure or SQL Azure platform account.