Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a Windows Server 2008 Server running SQL Server 2012 (including SSRS). I've noticed that the site is intermittently slow on first run, and found this blog post about the cause and how to fix it.

However, when I open the server manager for either of my servers (dev and production) they don't seem to have IIS installed.

Production:

enter image description here

On my dev server, I installed the IIS role, but I can't see anything to do with Reporting Services there:

enter image description here

Why can't I see anything to do with SSRS here? The web sites for both servers work fine.

share|improve this question
add comment

1 Answer 1

up vote 4 down vote accepted

As of SQL Server 2008, IIS is no longer used by SQL Server Reporting Services. It utilizes the HTTP.sys API now. So you will not see SSRS show up as a site or application pool.

The tip you linked to deals with SQL Server 2005, which required IIS in order to use SSRS. This tip speaks of the slowness you might be seeing and how to address it in SQL Server 2008/2008 R2. I would test to see if the same results are seen in 2012 version.

share|improve this answer
    
Good to know, thanks! Do you have an official source explaining this change by any chance? –  Mansfield Apr 16 at 13:42
1  
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.