Database Reference
In-Depth Information
The Report Manager website URL can also be used to identify whether Reporting Services is working
correctly. If you have previously opened the web service, the Report Manager web application should start
up rather quickly. If you go directly to the Report Manager application without accessing the web service first,
it will take a few minutes for it to open, because, as we just stated, it must start the web service application
before it can display its content. This is perfectly normal and will not affect your end user's system.
When you first install Reporting Services, it will not include any reports. So, when the websites are accessed,
the web pages will appear with a header at the top and a mostly blank area beneath that. We discuss how to
change that next.
WheN thINGS GO WrONG
Even if you cannot get the web and Windows services running correctly, you can still create and test your
SSRS reports for the rest of the book. The problems come when you try to follow along with some of the
administration tasks outlined at the end of the chapter. If you have not managed to get the Reporting
Services running correctly by then, you will only be able to read about how the administration tasks are
performed, which won't be as much fun, although it will still be informative. We prefer that you follow along
throughout the chapter, however, so here are some tips for troubleshooting SSRS installations.
the Databases
normally, the SSRS databases are created during the installation of SQL Server, but occasionally they are not.
You need the database if you want to perform SSRS administration. You can use SQL Server Management
Studio to verify that the Report Server databases are installed. If you do not see them there, you can assume
you found the problem. To fix this issue, use the database page of the Reporting Server Configuration
Manager to manually add the databases. Microsoft provides a wizard that easily walks you through the
process, which is accessed by clicking the Change Database button shown in Figure
16-12
.
