Groups | Blog | Home
all groups > sql server reporting services > june 2006 >

sql server reporting services : Blank Home Page in Report Manager - no reports showing


craniaamericana NO[at]SPAM gmail.com
6/20/2006 8:22:28 AM
I have Reporting Services installed on SQL Server 2005 computer at our
hosting facility. Domain serves only the databases at this point.

I have deployed two reports. When viewing from the SQL Server computer
itself they display without issue and everything appears as normal but
remote connections do not show reports.

My office is on the other side of the firewall. If I browse to the
report manager (only port 80 is open) I am prompted to log in, the
login is accepted (trying admin account for the domain), but no reports
show. All I am presented with is the link to Home (with no content)
the link to My Subscriptions (shows message "... no items to view
...."), and the link to Help - which works correctly.

I'm assuming it is a problem at the firewall, but am not sure what
needs to happen at this point. It could be a permissions issue
concerning logging on from within the domain or outside of the domain.

Any help is appreciated - have spent a day trying to hunt down a
solution with no luck.
SK
6/21/2006 9:34:03 AM
Not sure if this would solve your problem.
If you see the home page, but not the report, then it might be an account
permission issue. What kind of error message do you get, if any?

You need permission to the database wherever it is depending on your account
created whether it's Windows Authentication or SQL Login and also
If you haven't already, you need to create a New Role Assignment under the
Properties in the Home page of RM for Domain\User.





[quoted text, click to view]
AddThis Social Bookmark Button