March 18, 2009 at 5:43 am
Hi 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 workstation
SQL Server 2005 Developer version - and then applied SP2
IIS 5.0
All seems to install fine.
Reporting Services Configuration - fine
PC running as a web server - fine
SSMS - fine (both ReportServer and ReportServerTempDB installed)
BUT, cannot access Reporting Services through SSMS - operation timed out
nor, 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:
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\ASPNET
ReportingServicesService!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: Developer
ReportingServicesService!resourceutilities!4!18/03/2009-10:26:08:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!library!8!18/03/2009-10:26:14:: i INFO: Catalog SQL Server Edition = Developer
ReportingServicesService!crypto!8!18/03/2009-10:26:14:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!8!18/03/2009-10:26:14:: i INFO: Exporting public key
ReportingServicesService!crypto!8!18/03/2009-10:26:15:: i INFO: Performing sku validation
ReportingServicesService!crypto!8!18/03/2009-10:26:15:: i INFO: Importing existing encryption key
ReportingServicesService!dbpolling!8!03/18/2009-10:26:15:: i INFO: EventPolling polling service started
ReportingServicesService!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 started
ReportingServicesService!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 started
ReportingServicesService!dbpolling!8!03/18/2009-10:26:15:: i INFO: UpgradePolling polling service started
ReportingServicesService!dbpolling!c!18/03/2009-10:26:15:: i INFO: Polling started
ReportingServicesService!runningjobs!8!03/18/2009-10:26:15:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!8!03/18/2009-10:26:15:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!8!03/18/2009-10:26:15:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!8!03/18/2009-10:26:15:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 56024 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!8!03/18/2009-10:26:15:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!8!03/18/2009-10:26:15:: i INFO: SQM timer timer enabled: Next Event: 59624 seconds. Cycle: 86400 seconds
ReportingServicesService!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 streams
ReportingServicesService!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 stopped
ReportingServicesService!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 stopped
ReportingServicesService!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 stopped
ReportingServicesService!dbpolling!4!18/03/2009-10:37:48:: i INFO: UpgradePolling polling service stopped
ReportingServicesService!servicecontroller!4!18/03/2009-10:37:48:: i INFO: Service controller exiting.
IIS Log:
#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 302
11:19:00 10.171.5.201 GET /localstart.asp 401
11:19:00 10.171.5.201 GET /win2000.gif 304
11:19:00 10.171.5.201 GET /warning.gif 304
11:19:00 10.171.5.201 GET /localstart.asp 200
11:19:00 10.171.5.201 GET /web.gif 304
11:19:00 10.171.5.201 GET /mmc.gif 304
11:19:00 10.171.5.201 GET /help.gif 304
11:19:00 10.171.5.201 GET /print.gif 304
11:19:00 127.0.0.1 GET /iishelp/Default.htm 304
11:19:00 127.0.0.1 GET /iishelp/iis/misc/default.asp 200
11:19:00 127.0.0.1 GET /iishelp/iis/misc/contents.asp 200
11:19:00 127.0.0.1 GET /iishelp/iis/misc/navbar.asp 200
11:19:00 127.0.0.1 GET /iishelp/iis/misc/navpad.gif 304
11:19:00 127.0.0.1 GET /iishelp/iis/htm/core/iiwltop.htm 304
11:19:00 127.0.0.1 GET /iishelp/iis/misc/MS_logo.gif 304
11:19:00 127.0.0.1 GET /iishelp/iis/misc/ismhd.gif 304
11:19:00 127.0.0.1 GET /iishelp/iis/misc/Cont.gif 304
11:19:00 127.0.0.1 GET /iishelp/iis/misc/NoIndex.gif 304
11:19:00 127.0.0.1 GET /iishelp/iis/misc/NoSearch.gif 304
11:19:00 127.0.0.1 GET /iishelp/iis/misc/print.gif 304
11:19:00 127.0.0.1 GET /iishelp/iis/misc/synch.gif 304
11:19:00 127.0.0.1 GET /iishelp/iis/misc/cohhc.hhc 304
11:19:00 127.0.0.1 GET /iishelp/common/coua.css 304
11:19:00 127.0.0.1 GET /iishelp/iis/htm/core/iis_banr.gif 304
11:19:10 10.171.5.201 GET /reports/ 302
11:25:17 10.171.5.201 GET /reports/Home.aspx 302
11:27:52 10.171.5.201 GET /reports/Pages/Folder.aspx 500
11:27:52 127.0.0.1 POST /ReportServer/ReportService2005.asmx 500
Thanks,
Dom
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply