Problems installing/configuring Reporting Services

Question

Problems installing/configuring Reporting Services

Dom Horton

SSCrazy

Points: 2202
More actions
October 17, 2008 at 4:51 am

#199653

Hello,
I'm having great difficulty in getting RS working.
After doing a number of fresh installs I'm still unable to connect to either
http://localhost/reports or http://localhost/reportserver with Internet Explorer hangs as though its trying to connect.
I also cannot connect to the Reporting Services instance through SSMS and I'm getting a 'timed out' message.
During the install process the option to have the default configuration wasn't available, so I configured through the Reporting Services Configuration tool. This proved successful with the legend for each part 'green checked'
The most annoying part of this is that I've previously had Reporting Services running on this machine and in that case the installation was a doddle!
I'm at a loss as to why it's not working! After spending nearly two days at it with a number of reinstalls and trawling through various websites I thought its about time to post on here!
SQL Server 2005 SP2
Windows 2000
IIS 5.0
Thanks in advance,
Dom

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

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

Dom Horton SSCrazy Points: 2202 More actions · Answer 1

Yet again,

I've done a new install, accepting all the defaults. No errors occurred during installation and all install logs appear fine.

When attempting to access http://localhost/reports IE hangs......what is the problem???????

I'm sure I'm not the only person to have this occur!

Also, when using Surface Area Config for features, under Reporting Services, when trying to access Windows Integrated Security SAC freezes and doesn't respond.........herein lies the problem me thinks.......but would greatly appreciate some pointers from someone with more experience!!.....what could be the problem?

thanks,

dom

....anyone out there? i'm at my wits' end with this!!!

mjt-635800 SSC Enthusiast Points: 143 More actions · Answer 2

See if any of this helps you. It talks about an issue when trying to accessing url with /reports not working but /reportserver working.

http://blogs.msdn.com/lukaszp/archive/2008/07/18/reporting-services-http-401-unauthorized-host-headers-require-your-attention.aspx

Dom Horton SSCrazy Points: 2202 More actions · Answer 3

Many thanks for the response but it hasn't really helped matters!

I've compared my setup with that on another laptop and attempted to duplicate it, still to no avail.

One thing that concerns me is within the ReportingServices log theres a line:

ReportingServicesService!library!b!06/11/2008-11:11:59:: i INFO: Catalog SQL Server Edition = Developer

ReportingServicesService!resourceutilities!b!06/11/2008-11:11:59:: i INFO: Reporting Services starting SKU: Developer

ReportingServicesService!resourceutilities!b!06/11/2008-11:11:59:: i INFO: Evaluation copy: 0 days left

I'm currently using the Developer version but have had an Evaluation copy on this machine in the past. Could something be residing in the registry throwing a spanner in the works?

Thanks,

Dom

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 4

Is it possible to do a complete unistall? Then see if there are traces left over?

Did you try applying SP2 after the install?

Greg E

Dom Horton SSCrazy Points: 2202 More actions · Answer 5

Hello,

Thanks for the response, I've done what I think is a complete uninstall, but not looked for any residual traces.

After reinstallation, I've applies SP2 too.

I'm at a loss!

I'll uninstall again and see what happens.......

thanks,

dom

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 6

Dom,

First uninstall SQL Server 2005 completely (includes SP2). for more information see the link: http://support.microsoft.com/kb/909967

(in the above link, follow the Step 2 as it as).

After that install SQL Server 2005, while installing auth. mode set to Mixed mode. and choose the option, configure Reporting Server after install (like that...)

Note: Before uninstalling, take the back-up of your databases or copy the data folder into another location, after installed, just restore or attach the databases.

Dom Horton SSCrazy Points: 2202 More actions · Answer 7

Thanks for the reply,

i'm now getting the error in the log:

ReportingServicesService!dbpolling!c!10/11/2008-14:13:32:: 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 - No process is on the other end of the pipe.)

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!10/11/2008-14:13:45:: 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: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)

at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)

at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()

at System.Data.SqlClient.TdsParserStateObject.ReadByte()

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

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!10/11/2008-14:13:45:: 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: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)