SSRS – Configure for local network access

See next blog entry.
This entry was written when trying to use VS-TFS reports on Windows 7. This is not possible, so do not try. However configuration below does work over home network.
Found a TFS report cofiguration help website that said use Local System. This is for 2008 but still works
then on this page look for “To verify or correct the configuration of SQL Server Reporting Services”
On same page it says .. howeve the real reason in 2010 at least is because W7 does not support this.

Documents and Reports are Unavailable in Team Explorer

When you connect to Team Foundation Server using Team Explorer, the Documents and Reports nodes of a project may be unavailable. This is indicated by a red x on the nodes. This may indicate that the firewall on the computer that hosts Team Foundation Server does not have an exception configured for port 80. You must add this port to the exception list for your firewall application. For more information, see How to: Verify or Correct Port Assignments.


This works – other configurations may also work
Normal configuration
Service account = Local Service
Database credentials windows account
On other computer
Internet Explorer > Tools Internet Options > Security > Trusted Sites > Sites > http://nameofserver
On report server computer
Go to report manager url > Home > Folder settings > New Role Assignment > Include Content Manager

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: