Friday, March 23, 2012

Is it possible to deploy reports on server and view it from client machines

Hi,

I'm a newbie to reporting service.

I deployed a report on the server. When I viewed it on the server by entering the URL of http://localhost/reports$SQLExpress, everything's fine. When I tried to view it form a client machine on http://MyServerName/reports$SQLExpress, it failed. I did assign a role to the client user. I'm just wondering whether it is possible to do this.

I'm using SQL Express, the server runs win2003 server and the client machine runs winXP.

What was the error message? What authentication method are you using for reporting services?

sluggy

|||

The error message was"The page cannot be displayed. The page you are looking for is currently unavaiable. blah...blah...".

I use Windows authentication for reporting service. Thanks!

|||

You are probably hitting the double-hop problem with IIS

http://blogs.msdn.com/jgalla/archive/2006/03/16/553314.aspx

The fix is to store the credentials for accessing the datasource in the report server.

No comments:

Post a Comment