There were two functioning reporting services 2008, one from FEB 2008 CTP and the Other from SQL Server 2008 RC0.
Both were installed in native mode.
The Report Manager URL and Web Service URL were accessible for a couple of days.
Looks like there was an automatic Windows update on July 1
.
The URL access capability is gone - the IE's Web Page not found error gets displayed.
Appreciate any help in this problem.
Thanks
Here are my observations.
=========================
Control Panel/Services:
Can start/stop Database Engine Instance as well as Reporting Services for the CTP as well as the RC0.
============================
SQL Server Management Studio:
Can connect to Database Engine instance
Cannot Connect to Reporting Services
Error notification as follows:
TITLE: Connect to Server
------------------------------
Cannot connect to HODENTEK2\SANGAM.
------------------------------
ADDITIONAL INFORMATION:
Unable to connect to the server at HODENTEK2\SANGAM. The specified URL might not be valid or there might be a problem with the report server version or configuration. Specify a different URL, or contact your server administrator to verify that the report server runs SQL Server 2008 or later. Additionally, if you are trying to connect to a SharePoint-integrated report server, verify that SharePoint is installed on the server and that the report server uses SharePoint integrated mode. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
BUTTONS:
OK
=======================================
SQL Server Configuration Manager:
Can stop and start both instances of Reporting Services(Feb CTP and RC0)
Dump file after starting RS:
Filelocagtion:C:\Program Files\Microsoft SQL Server\MSRS10.SANGAM\Reporting Services\LogFiles\
Filecontent:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 2007.0100.1442.032 ((SQL_PreRelease).080529-2343 )</Product>
<Locale>English (United States)</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSRS10.SANGAM\Reporting Services\Logfiles\ReportServerService__07_02_2008_15_34_28.log</Path>
<SystemName>HODENTEK2</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 3</OSName>
<OSVersion>5.1.2600</OSVersion>
<ProcessID>3272</ProcessID>
</Header>rshost!rshost!da4!07/02/2008-15:34:28:: i INFO: CLR runtime is initialized.
rshost!rshost!da4!07/02/2008-15:34:28:: i INFO: Derived memory configuration based on physical memory as 2087020 KB
appdomainmanager!DefaultDomain!34c!07/02/2008-15:34:28:: i INFO: Entered managed ServiceMain in DefaultDomain.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException' as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException' as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing AuthenticationTypes to '4' as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing EnableAuthPersistence to 'True' as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
library!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Initializing IsReportManagerEnabled to 'True' as specified in Configuration file.
configmanager!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Using report server internal url http://localhost:8080/ReportServer_SANGAM.
configmanager!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Using report server external url http://HODENTEK2:8080/ReportServer_SANGAM.
configmanager!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Using url root http://HODENTEK2:8080/ReportServer_SANGAM.
appdomainmanager!DefaultDomain!a00!07/02/2008-15:34:29:: i INFO: Appdomain:2 WindowsService_0 started.
resourceutilities!WindowsService_0!a00!07/02/2008-15:34:29:: i INFO: Reporting Services starting SKU: Standard
resourceutilities!WindowsService_0!a00!07/02/2008-15:34:29:: i INFO: Evaluation copy: 159 days left
resourceutilities!WindowsService_0!a00!07/02/2008-15:34:29:: i INFO: Running on 1 physical processors, 2 logical processors
rshost!rshost!170c!07/02/2008-15:34:29:: e ERROR: Failed to register url=http://+:8080/ReportServer_SANGAM/ for endpoint 2, error=20.
rshost!rshost!170c!07/02/2008-15:34:29:: w WARN: Endpoint 2 is enabled but no url is registered for vdir=/ReportServer_SANGAM, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.SANGAM\Reporting Services\ReportServer.
servicecontroller!DefaultDomain!a00!07/02/2008-15:34:29:: e ERROR: Error creating HTTP endpoint. System.IO.FileLoadException: The process cannot access the file because it is being used by another process. (Exception from HRESULT: 0x80070020)
at Microsoft.ReportingServices.HostingInterfaces.IRsUnmanagedCallback.CreateHttpEndpoint(RsAppDomainType application, String[] urlPrefixes, Int32 cPrefixes, String virtualDirectory, String filePath, Int32 authType, Int32 logonMethod, String authDomain, String authRealm, Boolean authPersist, Boolean enabled)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.SetWebConfiguration(RunningApplication rsApplication, Boolean enabled, String folder)
rshost!rshost!908!07/02/2008-15:34:29:: e ERROR: Failed to register url=http://+:8080/Reports_SANGAM/ for endpoint 3, error=20.
rshost!rshost!908!07/02/2008-15:34:29:: w WARN: Endpoint 3 is enabled but no url is registered for vdir=/Reports_SANGAM, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.SANGAM\Reporting Services\ReportManager.
servicecontroller!DefaultDomain!a00!07/02/2008-15:34:29:: e ERROR: Error creating HTTP endpoint. System.IO.FileLoadException: The process cannot access the file because it is being used by another process. (Exception from HRESULT: 0x80070020)
at Microsoft.ReportingServices.HostingInterfaces.IRsUnmanagedCallback.CreateHttpEndpoint(RsAppDomainType application, String[] urlPrefixes, Int32 cPrefixes, String virtualDirectory, String filePath, Int32 authType, Int32 logonMethod, String authDomain, String authRealm, Boolean authPersist, Boolean enabled)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.SetWebConfiguration(RunningApplication rsApplication, Boolean enabled, String folder)
rshost!rshost!13e4!07/02/2008-15:34:29:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer_SANGAM/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10.SANGAM\Reporting Services\ReportServer\ReportBuilder.
rshost!rshost!a00!07/02/2008-15:34:29:: i INFO: Derived memory configuration based on physical memory as 2087020 KB
servicecontroller!DefaultDomain!13e4!07/02/2008-15:34:29:: i INFO: Total Physical memory: 2137108480
rpcserver!DefaultDomain!908!07/02/2008-15:34:29:: i INFO: Process monitoring started.
library!WindowsService_0!cf4!07/02/2008-15:34:29:: i INFO: Catalog SQL Server Edition = Standard
crypto!WindowsService_0!cf4!07/02/2008-15:34:29:: i INFO: Initializing crypto as user: HODENTEK2\jay
crypto!WindowsService_0!cf4!07/02/2008-15:34:29:: i INFO: Exporting public key
crypto!WindowsService_0!cf4!07/02/2008-15:34:29:: i INFO: Performing sku validation
crypto!WindowsService_0!cf4!07/02/2008-15:34:29:: i INFO: Importing existing encryption key
dbpolling!WindowsService_0!cf4!07/02/2008-15:34:30:: i INFO: EventPolling polling service started
dbpolling!WindowsService_0!cf4!07/02/2008-15:34:30:: i INFO: NotificationPolling polling service started
dbpolling!WindowsService_0!cf4!07/02/2008-15:34:30:: i INFO: SchedulePolling polling service started
dbpolling!WindowsService_0!cf4!07/02/2008-15:34:30:: i INFO: UpgradePolling polling service started
dbpolling!WindowsService_0!170c!07/02/2008-15:34:30:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started.
dbpolling!WindowsService_0!f04!07/02/2008-15:34:30:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started.
dbpolling!WindowsService_0!d60!07/02/2008-15:34:30:: i INFO: PollingMaintenance: Polling started
runningjobs!WindowsService_0!cf4!07/02/2008-15:34:30:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
runningjobs!WindowsService_0!cf4!07/02/2008-15:34:30:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
runningjobs!WindowsService_0!cf4!07/02/2008-15:34:30:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
runningjobs!WindowsService_0!cf4!07/02/2008-15:34:30:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 37529 seconds. Cycle: 86400 seconds
runningjobs!WindowsService_0!cf4!07/02/2008-15:34:30:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
runningjobs!WindowsService_0!cf4!07/02/2008-15:34:30:: i INFO: SQM timer timer enabled: Next Event: 41129 seconds. Cycle: 86400 seconds
rpcserver!DefaultDomain!cf4!07/02/2008-15:34:30:: i INFO: RPC Server started.
servicecontroller!DefaultDomain!cf4!07/02/2008-15:34:30:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10.SANGAM'
appdomainmanager!WindowsService_0!cf4!07/02/2008-15:34:30:: i INFO: Appdomain:2 WindowsService_0 initialized.
library!DefaultDomain!d90!07/02/2008-15:34:45:: i INFO: Catalog SQL Server Edition = Standard
resourceutilities!DefaultDomain!d90!07/02/2008-15:34:45:: i INFO: Reporting Services starting SKU: Standard
resourceutilities!DefaultDomain!d90!07/02/2008-15:34:45:: i INFO: Evaluation copy: 159 days left