SQLSever 2005 Reporting Service doesn't work on domain/Reports but works fine on domain/ReportServer

Question

Post reply

SQLSever 2005 Reporting Service doesn't work on domain/Reports but works fine on domain/ReportServer

princa

SSCommitted

Points: 1819
More actions
February 25, 2010 at 3:34 pm

#230312

Hi guys,

I am facing a problem with SQLServer 2005 reporting service.

I published a site on IIS, let's say test.com. Then I start the reporting service server, then in the Reporting Services Configuration Manager, I connect with a DB and then create a new DB called test$2005 for the reporting service, and I use Service Credentials, everything is fine, all work!

Then, configure Report Server Virtual Directory, Named ReportServer with website test.com

Then, configure Report Manager Virtual Directory, named Reports with website test.com

Then, Windows Service Identity, Here the server name is gray with previous used name, should the name be the same with my current test$2005 DB name? Then service account I use localSystem, and built-in account with localSystem.

Then, for the Web Service Idendity, the ASP.NET Service Account is automatically assigned with LocalSystem, that I can't change, and then I select test$2005 for report server and report manager.

After that, server status is ok! but the Initialization ICON is gray with X-type. I don't know should be like this or not!

Then I check test.com/ReportServer, it's fine! Then I check test.com/Reports, it requires login info and then i got error:

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

Does anyone know how to fix this?

Thanks!

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

princa SSCommitted Points: 1819 More actions · Answer 1

And then I go to SQL Surface Area Configuration, checked Surface Area Configuration for Features with Reporting Services' Windows Integrated Security option, got error : The request failed with HTTP status 404: Not Found. (System.Web.Services)

Details:

The request failed with HTTP status 404: Not Found. (System.Web.Services)

------------------------------

Program Location:

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlSac.Public.ReportingWebServiceProxy.GetSystemProperties(Property[] Properties)

at Microsoft.SqlSac.Public.ReportingServices.GetSettings(String givenInstanceName, ReportingFeature feature, String serverName)

at Microsoft.SqlSac.MainPanel.WindowsIntegratedSecurity.GetCurrentSettings(String machineName)

at Microsoft.SqlSac.MainPanel.FormFeatures.DisplayLeaf(TreeView tree, ETreeNode selected)

at Microsoft.SqlSac.MainPanel.FormFeatures.OnTimer(Object source, ElapsedEventArgs eArgs)

Does anyone know why?

veeren4urs SSCrazy Points: 2763 More actions · Answer 2

veeren4urs

SSCrazy

Points: 2763

February 28, 2010 at 10:16 am

#1126283

Hi,

I think its Credentical issue,where u r reports(rdls) are deployed is it in ur local system or Nw system.

Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉

princa SSCommitted Points: 1819 More actions · Answer 3

princa

SSCommitted

Points: 1819

February 28, 2010 at 11:03 am

#1126295

I used Nw system to deploy in the reporting service, all positive response from reporting service, and I granted the local reportmanager and reportserivce folders to NW system as a full control. still the same question! 🙁 no idea.

veeren4urs SSCrazy Points: 2763 More actions · Answer 4

Hi,

If you get the error message: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.

If you then scan the recent logfiles in C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles and find the following exception: Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. ---> System.Net.WebException: The request failed with HTTP status 404: .

it means that you have configured the /reportserver/ app to not be reachable via http://localhost/... - there are two options from here:

1) add the localhost hostheader to the web-site which hosts the /reportserver/ and make sure the app is then reachable via that path

2) edit the file C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\RSWebApplication.config and add the full url to the ReportServer into the ReportServerUrl tag (no ending / nessesary) AND remove the value from ReportServerVirtualDirectory (otherwise you get nasty, unprecise exceptions). THEN you must recycle the app-pool used by the Report-Manager so that config file is being reloaded.

If u r not getting the above error...

send me the error info in the logfiles...

Thanks

Veeren.:-)

Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉

veeren4urs SSCrazy Points: 2763 More actions · Answer 5

veeren4urs

SSCrazy

Points: 2763

March 1, 2010 at 11:19 pm

#1126845

Hi,

Note:Please take a backup of ur files before u r going to modify any thing...

Thanks

Veeren..:-)

Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉

princa SSCommitted Points: 1819 More actions · Answer 6

Hi Veenes, I tried your way, actually, I can access to url/ReportServer, but I can't access url/Reports.

Now I made such changes:

1. add http://url/reports to the RSWebApplication.config between <ReportServerUrl> tag.

2. delete the <ReportServerVirtualDirectory> 's content.

Now when I try to access my reports, I got this:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.

Log is following:

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.

w3wp!library!1!3/4/2010-18:24:41:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.

w3wp!ui!5!3/4/2010-18:24:47:: Unhandled exception: System.Web.HttpException: The file '/reports/ReportService2005.asmx' does not exist.

at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath)

at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile)

at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile)

at System.Web.Compilation.BuildManager.GetVPathBuildResult(HttpContext context, VirtualPath virtualPath)

at System.Web.UI.WebServiceParser.GetCompiledType(String inputFile, HttpContext context)

at System.Web.Services.Protocols.WebServiceHandlerFactory.GetHandler(HttpContext context, String verb, String url, String filePath)

at System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig)

at System.Web.HttpApplication.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

w3wp!ui!1!3/4/2010-18:24:48:: e ERROR: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.

w3wp!ui!1!3/4/2010-18:24:48:: e ERROR: HTTP status code --> 500

-------Details--------

Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. ---> System.Net.WebException: The request failed with HTTP status 404: Not Found.

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

--- End of inner exception stack trace ---

at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

w3wp!ui!5!3/4/2010-18:24:48:: Unhandled exception: System.Web.HttpException: The file '/reports/ReportService2005.asmx' does not exist.