SQL Server 2008 Express Reporting Services on Windows 7

I had a crazy, frustrating time getting my SQL Server 2008 Express Edition with Advanced Services installation to let me access Reporting Services.  I followed a lot of different blog posts and suggestions that included tweaks to trusted sites, adjusting virtual directory permissions (which isn’t even applicable because the virtual directories don’t appear in IIS) and changing permissions on the database.  While these some of this is necessary, they weren’t all needed and they weren’t the whole solution. 

No matter what I did, this is what I saw when I went to Report Manager.  Notice that “Site Settings” is not an option:

image

And this is what I saw on the Report Server:

image

Continue reading

Advertisements