After having applied SP1 for SQL 2008 I always check SRS. Does it work? So I started IE and surfed to this address: http://localhost/reports. This is what I got:
Hmm. Looks almost good. SRS is working. Wait. Some buttons are missing!? Now what? So I set IE ESC for Users only. Still no luck. I set it back. I disabled Protected Mode. Still no luck. Set IE ESC for Users only again, so I have both adjustments now. Still no luck.
Seems OK to me. Then I added the site (http://localhost) to the list of sites for Local Intranet:
Closed IE, started IE and surfed to the SRS website. Still no luck! What about approaching this website from another server? I logged on to another server with the same credentials, started IE and surfed to the SRS website residing on the SQL server. Now I used the name of server instead of localhost (duh!). This is what I got:
And as we all know, Trusted Sites is more protected (more content is blocked) then Local Intranet, the setting on the SQL server itself! So why does it work from any other server but not from the SQL Server it self?
So time to use the internet. Found this posting of an SQL/SRS MVP but still no luck…
Okay, it is working. But still I am puzzled why without elevated permissions it works from any other server AND with higher security settings? Any one out there with an explanation, please step up and tell me. Since I am still puzzled here.
Good to know: Reporting installed fine since on Windows 2008 Server I run every installation with elevated permissions by default.