Cannot connect to ReportServer

Question

Cannot connect to ReportServer

GAPPO

SSC Rookie

Points: 32
More actions
September 9, 2007 at 7:11 am

#176559

Hello All,
I am trying to install and run SSRS 2005 on a Windows XP Pro workstation.
The installation completes and I have used the configuration tool to configure reporting services. All first six icons on the left are green. However, I cannot connect to the default report server from Management Studio and get the following message;
===================================
Client found response content type of 'text/html', but expected 'text/xml'.
The request failed with the error message:
--
<html><head><title>Server Application Error</title></head>
<body><h1>Server Application Error</h1>The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance.</body></html>
--. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
Program Location:
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
   at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
   at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
   at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
   at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
   at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
==========================================================================
I also cannot reach the reporting services website from Internet Explorer using /Reports/">http://<servername>/Reports/
getting the message '(HTTP 500 Internal Server Error)'.
Any one have any ideas how to resolve this?
I have successfully installed and run reporting services using the same SSRS 2005 Developer edition on three other Windows 2003 Server machines without any of these errors.
What is wrong or how can I get the installation to work on Windows XP workstation?

Viewing 9 posts - 1 through 9 (of 9 total)

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

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 1

Heh... maybe it figured out that you're breaking the license agreement and, therefore, the law by using the Developer Edition for production?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

GAPPO SSC Rookie Points: 32 More actions · Answer 2

No I am not using the developer edition for production. All three server installs are on development and test servers under development. I am still using sql 2000 for production. Can anyone help?

Ben-405845 Newbie Points: 5 More actions · Answer 3

You will need to get the actual error message. You can either get it from the ssrs log located under the sql server install folder, or try connecting to the report server on the local box.

Does your workstation have sql server sp2 installed. I would receive a 403 access forbidden error after I installed sql2005 sp2 on my computer. I actually had to uninstall sql server, and reinstall it leaving off sp2 to get it going again.

GAPPO SSC Rookie Points: 32 More actions · Answer 4

Ben,

The actual error message is as above in my first posting and, yes, I have sql 2005 sp2 installed, although reporting services did not work even before I installed sp2. I first thought that was the reason.

Is there any other work-around. I have seen reporting services work on more windows server 2003 machines but has anyone got it working on windows xp professional? Getting desperate now pls.........

Antares686 SSC Guru Points: 125444 More actions · Answer 5

Could be configuration. Have you tried opening from the server.

Connect to the server via remote desktop or walk to the server console and try to navigate to

http://localhost/reports

it still may not work but might give you a better reason as to why.

GAPPO SSC Rookie Points: 32 More actions · Answer 6

I have tried http://localhost/reports but no joy. I am installing on a pc workstation with windows xp prof. No server involved in this, just single machine installation.

Antares686 SSC Guru Points: 125444 More actions · Answer 7

Noticed it said posted to the event Log. Dd you check Event Viewer to see what was posted there?

venom9909 Newbie Points: 3 More actions · Answer 8

Since this is a workstation, non-server operating system, I would recommend using SQL Server Developer Edition, as this is best suited for such an environment. Put the installation CD/dvd in and begin the installation steps. When prompted then select only SSRS to install. There are notable differences in SSRS 2005 and SSRS 2008, most notably the requirement of IIS to be installed to support SSRS 2005. Also if you are installing this on a workstation that is running Vista there are some other obstacles that must be over come.