Cannot connect to "Reporting Services" using Microsoft Sql Server Management Studio.
Hi,
I installed latest SQL Server 2005 180 days trial version on my windows XP SP2 machine with the named instance "RS2005POC". I opened sql server management studio and selected
Server Type = Reporting Services
Server Name = localhost\RS2005POC
Authentication = Windows Authentication.
Connection failed with the following error message. Any help on this is much appreciated. Also I tried with "cjecw-h1708\RS2005POC" where cjecw-h1708(instead of localhost) is my machine name.
Other links to Reporting Services are fine. I am able to work with Report Builder, Report Manager etc.
Complete error info:
Client found response content type of 'text/html', but expected 'text/xml'.
The request failed with the error message:
--
<HEAD><TITLE>Unknown Host</TITLE></HEAD>
<BODY BGCOLOR="white" FGCOLOR="black"><H1>Unknown Host</H1><HR>
<FONT FACE="Helvetica,Arial"><B>
Description: Unable to locate the server named "<em>cjecw-h1708</em>" the server does not have a DNS entry. Perhaps there is a misspelling in the server name, or the server no longer exists. Double-check the name and try again.</B></FONT>
<HR>
<!-- default "Unknown Host" response (500) -->
</BODY>
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()
Thanks
Ravi,
