Hi Friends ,
I have a problem to access the sqlserver Reporting on different server. Actually I created Sql Server Reporting in one server with in that server i able to access the report. but out of that server that means another server webapplication i unable to access it. how can i rectify this problem.
Redirecting to the RS forum.
Mike
|||Let's begin by naming your servers Server 1 (Server with Reporting Services) and Server 2 (Web Server with Web Application). I am not quite able to understand the exact problem you are facing. Either you are ok running reports on Server 1 but when you log in to Server 2, you are unable to run the reports (Scenario A). Or you are trying to have a Web Application on server 2 access the reports and display them (Scenario B).
If Scenario A is your problem, then you probably have some type of authentication issue. Is SQL running on Server 1 or is it on a different server? If it is a different server, are you on a domain or are you running under a workgroup? Here is a webcast that speaks to "double-hop" authentication which you will need if you have three different servers involved: http://support.microsoft.com/kb/887682
If Scenario B, take a look at this article by Russell Christopher on impersonation and think about using it on your Web Application: http://blogs.msdn.com/bimusings/archive/2005/11/18/494436.aspx
If none of the above helps, please reply with a precise outline of your problem and setup and I will try again.
Good luck!
Larry Smithmier
No comments:
Post a Comment