Create a Reporting Service (Windows Azure SQL Reporting)
|SQL Reporting will discontinue service on October 31, 2014. See this FAQ for details. For reporting on Windows Azure, visit Virtual Machines on WindowsAzure.com.|
Use the management portal to create a new reporting service in SQL Reporting. At this time, there is no API for provisioning a service, so using the portal is required for this task.
While creating the service, you will need to make the following decisions:
Choose a subscription. If you have multiple subscriptions, you will need to select one of them for billing purposes.
Region for hosting the service. Windows Azure is a global network, with data centers located around the world. To reduce latency and egress charges, pick a data center that hosts your data. If data is hosted in multiple data centers, consider choosing a data center closest to report users.
Service administrator account. Administrator names cannot be changed or deleted, so you might want to specify an account name that maps to a job title or role rather than an individual person.
|Billing begins as soon as you create a reporting service and stops when you delete a service. For more information, see Accounts and Billing in Windows Azure SQL Reporting (Windows Azure SQL Reporting).|
To create a reporting service
Go to http://WindowsAzure.com and click PORTAL at the top of the page.
Sign in to Windows Azure using a Microsoft account that has access to your Windows Azure subscription.
When the portal opens, click SQL Reporting from the navigation pane to view the existing reporting services already defined for the current subscription. If none are defined, you can create a new reporting service to get started.
Click NEW at the bottom of the page.
Click QUICK CREATE to specify the minimum information necessary to provision a service. This includes a service name, region, administrator, and password.
In Service Name, enter a name that will help you identify and manage the service in the portal. This name is used only in portal pages. You cannot use it as a Web service URL. Windows Azure will assign a service GUID that uniquely identifies your service instance in the cluster.
In the Region list, select a region. You can create only one report server in each of the available regions for each subscription. To improve report performance, try to choose a region that also hosts the SQL Database data sources you will use in your reports.
In the Administrator box, type the user name of the report server administrator and password. On SQL Reporting in Windows Azure, a report server administrator is granted Content Manager permission. The System Administrator or System User roles used in an on-premises report server do not apply in SQL Reporting.
Consider specifying a generic name (such as ContosoAdmin). The administrator name cannot be changed or deleted, so you might want to specify an account name that maps to a job title rather than an individual person.
Be sure to keep the account and password information in a safe place. You will need it to access the reporting service, create and manage user accounts, and grant permissions.
Click the check mark next to CREATE SQL REPORTING SERVICE.
The reporting service is created for the current subscription.
The reporting service name is a 10 character GUID. It appears in the web service URL on the main SQL Reporting page. The URL format of the complete service name is
Later, when you connect to this service via a web browser, you can connect using that URL, providing the credentials of the service administrator. You can also connect to the service using the management portal.