Database Reference
In-Depth Information
The account that you choose will also be used for more than just connecting to SQL Server databases.
Depending on how you set up SSRS, you can also interact with mail servers, network shares, and domain
controllers. This means that if you are planning to use features that would involve those servers, you must also
expect to configure the Windows account to have access to these items.
■
We use the Windows administrator account to avoid permission issues, but of course this is not recommended
practice for production, because it represents a security risk. In this topic, we have been using an administrator account
that provides access to SQL. In production, it is a very common issue to be unable to gain access to the Windows
account. Microsoft's website provides a considerable amount of advice to aid you in configuring the Reporting Services
service account.
Tip
The web service URL page is helpful in identifying whether Reporting Services is working correctly
(Figure
16-11
). A hyperlink on this page launches your browser and tries to navigate to the Reporting Services
web service. At first, the web service will be unresponsive. It takes a few minutes to come alive, so assume that
first request may take a minute or so before the web page will open successfully. This will happen every time
you reboot your computer.
Figure 16-11.
The web Service URL page of the Configuration Manager
