Problems installing/configuring Reporting Services

Question

Problems installing/configuring Reporting Services

Viewing 15 posts - 16 through 30 (of 30 total)

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

Doug S. SSCrazy Points: 2801 More actions · Answer 1

Dom thanks for replying. After a little reading here

http://msdn.microsoft.com/en-us/library/ms143736.aspx

I still did not have success, so I decided to use one of my MS partner tickets. I was on the phone for 4+ hours on Friday and its still FUBAR. I had the guy stumped. We were able to work around the 401 problem, but now it looks like some sort of a DNS or IP routing problem.

BTW - beware of aspnet_RegIIS I think this hosed a website on this box that it .Net 1.1. It's been a disaster. The website works but the rendering of Treeview controls is hosed. I need an urgent fix for this now.

Tomorrow, I will talk to my MS tech support guy and see what's up. The current problem is that report manager times out trying to reach report server, even though I can browse Report server directly? it makes no sense.

On top of this, i have 2 other servers where it works great. Hang on for more updates.

Doug

Doug S. SSCrazy Points: 2801 More actions · Answer 2

As a FYI, before you go and try aspnet_regiis on anything other than a test server the postings at the link below. The command looks benin, but as usual, there are unknown side effects depending on what's running on the box.

http://geekswithblogs.net/paulmehner/archive/2005/08/03/48970.aspx

They recommend that you use:

aspnet_regiis -ir -enable - Installs ASP.NET version with root and enables it.

aspnet_regiis -s path - Registers script map for our Application.

Hope this helps

:Whistling:

Doug

Dom Horton SSCrazy Points: 2202 More actions · Answer 3

Thanks Doug for sharing this with me,

I'll have a look into the comments and links you provided when I get a mo'.

regards,

dom

Doug S. SSCrazy Points: 2801 More actions · Answer 4

Dom, I'm still working on this with my new friends at Microsoft. I will post back when I have an update.

Doug

Doug S. SSCrazy Points: 2801 More actions · Answer 5

Ok, Dom I got my problem resolved but I don't have a great explanation of how I fixed it. Send me some particulars of your problem and I'll try to squeeze out some time to respond.

Some how the custom HTTP headers on the web site contained a HTTP definition (I think this was when I ran the .NET registration utility). When the Reports manager site got loaded, it called the report server site (via Web services I presume) and when IIS put the HTML type in the header (if overrode the XML type) and the page got a 500 error (Server not responding) in the logs.

For Days we believed the URL was wrong, yet we could browse there in IE. Turned off custom HTTP headers and report manager page loads right up.

Good Luck

Doug

Dom Horton SSCrazy Points: 2202 More actions · Answer 6

Hi Doug,

I've eventually come back to this....tried a fresh install on another PC...Windows 2000, SQL Server 2005 SP2 Developer version. 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 cliking 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)