From the course: SQL Server 2008 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Connecting to the Report Manager

Connecting to the Report Manager - SQL Server Tutorial

From the course: SQL Server 2008 Essential Training

Start my 1-month free trial

Connecting to the Report Manager

When I installed SQL Server I had checked the boxes to install Reporting Services as well. Now it's time to go and see what that means. You've probably seen that in Management Studio we have a couple of databases with the word Report on them, ReportServer and ReportServerTempDB. Those are support databases for this part of SQL Server called Reporting Services, though we're not going to touch them manually in SQL Server Management Studio. So I am just going to exit out of that and if you'd also taken a look at Configuration Manager, the regular SQL Server Configuration Manager, you'd see that Reporting Services is actually running in the background as its own application, its own service, and it really is a very substantial part of this whole enterprise application. But how do we work with it? Well for a start we have a new tool to work with. I am going to go to my SQL Server 2008 R2 applications into Configuration Tools and pick this time the Reporting Services Configuration Manager…

Contents