How to: Create a Reporting Service (Windows Azure SQL Reporting)

1. Connect to SQL Reporting (Windows Azure SQL Reporting).

2. Click NEW at the bottom of the page.

3. Click QUICK CREATE to specify the minimum information necessary to provision a service. This includes a service name, region, administrator, and password.

4. 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.

5. 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.

6. In the 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 report server, create and manage user accounts, and grant permissions.

7. Click the check mark next to CREATE SQL REPORTING SERVICE.

   The report server is created for the current subscription.

   The report server name is a 10 character GUID. It appears in the web service URL on the main SQL Reporting page.

Concepts