|
|
You're in the
sql server reporting services
group:Trial SQL Server 05 BI Reports Can't get IIS working with reports
sql server reporting services:
have searched this group and don't see my exact problem which is this: I installed VS 05, SQL 05 so that I could test out the BI Reports stuff. I can build reports. SQL works nicely. The report builder works nicely. I can see that IIS Web Services is running because I created a separate virtual directory and put a test.html which works from http://localhost/test.html. But whenever I try to browse any of the report stuff (reports ReportServer ReportManager etc.. ) http://localhost/Reports fails with 500 http://localhost/index.htm works ( so I know the IIS webserver is running - right?) The configuration tool for reporting services also looks right, says its on, seems to have all the right stuff. I think that my problem is something basic in my XP SP2 set up such that the ReportServer which is supposed to be running under IIS won't authenticate me directly and or thru VS when I try to deploy a report. What basic thing am I missing here? At this point I could give a rats ass about security, I just want to be able to deploy a report to the Report Server and then access it from within IIS. Why is this so flippin hard? Rich S.
Enrique, thanks for the response. I did the following:
Within IIS ->right clicked on Reports ->Properties -> Directory Service -> Edit -> CHECKED the box for anonymous Access -> Checked Allow IIS to control pw Check Integrated Windows Authentication Did this for both Reports and Report Server Made sure both RPC services were running [ Service and Locator ] Using IE5.1 IIS Services Not sure about the pool stuff. None of that seemed to make any difference, I still can not browse to anything in the reports directory. Maybe I have to put something in there first?? But than that does not explain why VS2005 BI Reports can't connect to do the deployment to http://localhost/ReportServer. With the server off, this is what VS2005 provides during the attempt to deploy the report (connection failure) =================================== A connection could not be made to the report server http://localhost/ReportServer. (Microsoft Report Designer) =================================== Unable to connect to the remote server (Microsoft.ReportingServices.Designer) ------------------------------ Program Location: at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods() at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname) at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item) at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item) at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized() at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url) at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy() =================================== No connection could be made because the target machine actively refused it (System) ------------------------------ Program Location: at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception) With the server turned on in IE I get this detail during the same attempted deployment ================================== A connection could not be made to the report server http://localhost/ReportServer. (Microsoft Report Designer) =================================== Client found response content type of 'text/html', but expected 'text/ xml'. The request failed with the error message: -- <html><head><title>Server Application Error</title></head> <body><h1>Server Application Error</h1>The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance.</body></html> --. (Microsoft.ReportingServices.Designer) ------------------------------ Program Location: at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods() at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname) at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item) at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item) at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized() at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url) at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy() Rich S.
[quoted text, click to view]
On Aug 30, 8:19 pm, richard.r.schnei...@gmail.com wrote: > Ok, I am stumped. I am obviously missing something really trivial. I > have searched this group and don't see my exact problem which is this: > I installed VS 05, SQL 05 so that I could test out the BI Reports > stuff. I can build reports. SQL works nicely. The report builder > works nicely. I can see that IIS Web Services is running because I > created a separate virtual directory and put a test.html which works > fromhttp://localhost/test.html. But whenever I try to browse any of > the report stuff (reports ReportServer ReportManager etc.. )http://localhost/Reports fails with 500http://localhost/index.htmworks ( so I know the IIS webserver is > running - right?) > The configuration tool for reporting services also looks right, says > its on, seems to have all the right stuff. > > I think that my problem is something basic in my XP SP2 set up such > that the ReportServer which is supposed to be running under IIS won't > authenticate me directly and or thru VS when I try to deploy a report. > > What basic thing am I missing here? At this point I could give a rats > ass about security, I just want to be able to deploy a report to the > Report Server and then access it from within IIS. Why is this so > flippin hard? > > Rich S. A few things to check: - Check the Virtual Directories for SSRS (Reports and ReportServer) and determine if Anonymous Access is set by itself, this is usually the problem. You will want to at least have Integrated Windows Authentication set via: Virtual Directory -> right-click -> Properties -> Directory Security tab -> Edit... button. - Check to make sure that the RPC (Remote Procedure Call) service is running. - If you are using IE7, you will want to create an additional application pool and set the SSRS Virtual Directories to use that one. Hope this helps. Regards, Enrique Martinez Sr. Software Consultant
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |