InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 04:30:53 GMT20http://www.sqlservercentral.com/Forums/Topic678295-150-1.aspxHi folks, After a break from RS....I decided to install SQL Server 2005 including all components on test workstation PC but have run in to difficulties getting Reporting Services running.Winodws 2000 SP4 workstationSQL Server 2005 Developer version - and then applied SP2IIS 5.0All seems to install fine.Reporting Services Configuration - finePC running as a web server - fineSSMS - fine (both ReportServer and ReportServerTempDB installed)BUT, cannot access Reporting Services through SSMS - operation timed outnor, using SAC for features, under Reporting Services, when clicking on the Windows Integrated Security option, it freezes and doesn't respond.nor, going to http://machinename/reports I get the message 'Server Application Unavailable'.Here are a couple of logs:Reporting Services Log:[size="1"] ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.ReportingServicesService!configmanager!4!18/03/2009-10:26:07:: w WARN: WebServiceAccount is not specified in the config file. Using default: EDU6006654\ASPNETReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.ReportingServicesService!library!4!18/03/2009-10:26:07:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.ReportingServicesService!resourceutilities!4!18/03/2009-10:26:08:: i INFO: Reporting Services starting SKU: DeveloperReportingServicesService!resourceutilities!4!18/03/2009-10:26:08:: i INFO: Evaluation copy: 0 days leftReportingServicesService!library!8!18/03/2009-10:26:14:: i INFO: Catalog SQL Server Edition = DeveloperReportingServicesService!crypto!8!18/03/2009-10:26:14:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEMReportingServicesService!crypto!8!18/03/2009-10:26:14:: i INFO: Exporting public keyReportingServicesService!crypto!8!18/03/2009-10:26:15:: i INFO: Performing sku validationReportingServicesService!crypto!8!18/03/2009-10:26:15:: i INFO: Importing existing encryption keyReportingServicesService!dbpolling!8!03/18/2009-10:26:15:: i INFO: EventPolling polling service startedReportingServicesService!dbpolling!a!18/03/2009-10:26:15:: i INFO: EventPolling heartbeat thread started.ReportingServicesService!dbpolling!8!03/18/2009-10:26:15:: i INFO: NotificationPolling polling service startedReportingServicesService!dbpolling!b!18/03/2009-10:26:15:: i INFO: NotificationPolling heartbeat thread started.ReportingServicesService!dbpolling!8!03/18/2009-10:26:15:: i INFO: SchedulePolling polling service startedReportingServicesService!dbpolling!8!03/18/2009-10:26:15:: i INFO: UpgradePolling polling service startedReportingServicesService!dbpolling!c!18/03/2009-10:26:15:: i INFO: Polling startedReportingServicesService!runningjobs!8!03/18/2009-10:26:15:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 secondsReportingServicesService!runningjobs!8!03/18/2009-10:26:15:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 secondsReportingServicesService!runningjobs!8!03/18/2009-10:26:15:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 secondsReportingServicesService!runningjobs!8!03/18/2009-10:26:15:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 56024 seconds. Cycle: 86400 secondsReportingServicesService!runningjobs!8!03/18/2009-10:26:15:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 secondsReportingServicesService!runningjobs!8!03/18/2009-10:26:15:: i INFO: SQM timer timer enabled: Next Event: 59624 seconds. Cycle: 86400 secondsReportingServicesService!library!4!18/03/2009-10:36:16:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streamsReportingServicesService!dbpolling!c!18/03/2009-10:36:46:: e ERROR: Polling caught an exception, restarting polling. Error Message System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - The pipe is being closed.) at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.WriteSni() at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode) at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush() at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteReader() at Microsoft.ReportingServices.Library.DBPoll.PollingFunction() at Microsoft.ReportingServices.Library.DBPoll.PollingStartFunction().ReportingServicesService!library!c!18/03/2009-10:37:02:: 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: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace ---ReportingServicesService!dbpolling!c!18/03/2009-10:37:02:: e ERROR: Polling caught an exception, restarting polling. Error Message 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: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace --- at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage() at Microsoft.ReportingServices.Library.DBPoll.PollingFunction() at Microsoft.ReportingServices.Library.DBPoll.PollingStartFunction().ReportingServicesService!library!c!18/03/2009-10:37:09:: i INFO: Polling started again.ReportingServicesService!dbpolling!4!18/03/2009-10:37:48:: i INFO: EventPolling polling service stoppedReportingServicesService!dbpolling!a!18/03/2009-10:37:48:: i INFO: EventPolling heartbeat thread exiting for stop.ReportingServicesService!dbpolling!4!18/03/2009-10:37:48:: i INFO: NotificationPolling polling service stoppedReportingServicesService!dbpolling!b!18/03/2009-10:37:48:: i INFO: NotificationPolling heartbeat thread exiting for stop.ReportingServicesService!dbpolling!4!18/03/2009-10:37:48:: i INFO: SchedulePolling polling service stoppedReportingServicesService!dbpolling!4!18/03/2009-10:37:48:: i INFO: UpgradePolling polling service stoppedReportingServicesService!servicecontroller!4!18/03/2009-10:37:48:: i INFO: Service controller exiting.[/size]IIS Log:[size="1"]#Software: Microsoft Internet Information Services 5.0#Version: 1.0#Date: 2009-03-18 11:19:00#Fields: time c-ip cs-method cs-uri-stem sc-status 11:19:00 10.171.5.201 GET /iisstart.asp 30211:19:00 10.171.5.201 GET /localstart.asp 40111:19:00 10.171.5.201 GET /win2000.gif 30411:19:00 10.171.5.201 GET /warning.gif 30411:19:00 10.171.5.201 GET /localstart.asp 20011:19:00 10.171.5.201 GET /web.gif 30411:19:00 10.171.5.201 GET /mmc.gif 30411:19:00 10.171.5.201 GET /help.gif 30411:19:00 10.171.5.201 GET /print.gif 30411:19:00 127.0.0.1 GET /iishelp/Default.htm 30411:19:00 127.0.0.1 GET /iishelp/iis/misc/default.asp 20011:19:00 127.0.0.1 GET /iishelp/iis/misc/contents.asp 20011:19:00 127.0.0.1 GET /iishelp/iis/misc/navbar.asp 20011:19:00 127.0.0.1 GET /iishelp/iis/misc/navpad.gif 30411:19:00 127.0.0.1 GET /iishelp/iis/htm/core/iiwltop.htm 30411:19:00 127.0.0.1 GET /iishelp/iis/misc/MS_logo.gif 30411:19:00 127.0.0.1 GET /iishelp/iis/misc/ismhd.gif 30411:19:00 127.0.0.1 GET /iishelp/iis/misc/Cont.gif 30411:19:00 127.0.0.1 GET /iishelp/iis/misc/NoIndex.gif 30411:19:00 127.0.0.1 GET /iishelp/iis/misc/NoSearch.gif 30411:19:00 127.0.0.1 GET /iishelp/iis/misc/print.gif 30411:19:00 127.0.0.1 GET /iishelp/iis/misc/synch.gif 30411:19:00 127.0.0.1 GET /iishelp/iis/misc/cohhc.hhc 30411:19:00 127.0.0.1 GET /iishelp/common/coua.css 30411:19:00 127.0.0.1 GET /iishelp/iis/htm/core/iis_banr.gif 30411:19:10 10.171.5.201 GET /reports/ 30211:25:17 10.171.5.201 GET /reports/Home.aspx 30211:27:52 10.171.5.201 GET /reports/Pages/Folder.aspx 50011:27:52 127.0.0.1 POST /ReportServer/ReportService2005.asmx 500[/size]Thanks,DomWed, 18 Mar 2009 05:43:02 GMTDom Horton