I installed SQL Server 2005.
I am trying to configure Team Foundation Server, but before installing it I want Report Server to work.
The service logs in as the local administrator. Yet it seems like SQL Server doesn't like Administrator to much...
Here's the log of the error when I try to browse reportserver.asmx from IIS.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__12_11_2005_12_42_20.log</Path>
<SystemName>MY_SERVER_NAME</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!webserver!1!12/11/2005-12:42:22:: i INFO: Reporting Web Server started
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!12/11/2005-12:42:23:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!12/11/2005-12:42:23:: i INFO: Reporting Services starting SKU: Enterprise
w3wp!resourceutilities!1!12/11/2005-12:42:23:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!1!12/11/2005-12:42:23:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!12/11/2005-12:42:23:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!12/11/2005-12:42:23:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!12/11/2005-12:42:23:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!12/11/2005-12:42:24:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()
at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!12/11/2005-12:42:30:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!12/11/2005-12:43:27:: i INFO: Catalog SQL Server Edition = Enterprise
w3wp!library!1!12/11/2005-12:43:27:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()
at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!12/11/2005-12:43:34:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!12/11/2005-12:47:34:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()
at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!12/11/2005-12:47:40:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!12/11/2005-12:47:40:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()
at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
End of inner exception stack trace
Thanks for your help
Cos
Make sure configuration/system.web/authentication node is present in your web.config file.|||Dmitry
Good afternoon
Can you tell me which web.config file must have this element?
I've been suffering from this error for two weeks and I still havent found a solution.
Thank you since now.
Jo?o Talles Dantas Batista
jtdbf@.hotmail.com
|||
Perhaps it has something to do with the line:
Evaluation copy: 0 days left
|||I have the same problem. I also saw the line
'ReportingServicesService!resourceutilities!a!7/4/2007-13:18:03:: i INFO: Evaluation copy: 0 days left'
but since the installed software is from the company's Microsoft subscription, I didn't think it was meaningful.
Current development is on my local machine running both 8.0 and 9.0 (SP2). The 8.0 seems functional but the named instance of the 9.0 stuff is still not working. The Virtual directories are there and appear to be pointed in to the correct locations. The services, according to the operating system are running. I am sure that it is something that I have either missed or done incorrectly in the configuration but, so far, I can't figure out where the problem is.
ReportingServicesService!library!4!7/5/2007-10:32:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Any insights would be greatly appreciated.
Thanks
Dennis Keith
|||Hi,
I did change in Report server Web.confing file.
<pages validateRequest="false" />
<authentication mode="Windows" />
<identity impersonate="true" />
I add authentication mode...and it works fine...
Thank you very much for your solution.
Regards,
Balwant Pate.
No comments:
Post a Comment