Thursday, March 22, 2012

Connecting to Server Fails

I'm running SQL Server 2005 RTM on my laptop (Dell Latitude D810) but
cannot connect to Reporting Services Server. When I try to connect to
it using SQL Server Management Studio (using windows authentication) I
get the following Error message...
TITLE: Connect to Server
--
Cannot connect to {ServerName}.
--
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your
connection information and that the report server is a compatible
version. (Microsoft.SqlServer.Management.UI.RSClient)
--
The request failed with HTTP status 404: Object Not Found.
(Microsoft.SqlServer.Management.UI.RSClient)
I have visual studio 2005 on the machine (which I installed after the
SQL Server install) and have .NET Framework version 2.0.50727.42.
The OS is windows XP Professional.
Anyone know what I will need to do to connect to the server?Simon Worth wrote:
> I'm running SQL Server 2005 RTM on my laptop (Dell Latitude D810) but
> cannot connect to Reporting Services Server. When I try to connect to
> it using SQL Server Management Studio (using windows authentication) I
> get the following Error message...
> TITLE: Connect to Server
> --
> Cannot connect to {ServerName}.
> --
> ADDITIONAL INFORMATION:
> The attempt to connect to the report server failed. Check your
> connection information and that the report server is a compatible
> version. (Microsoft.SqlServer.Management.UI.RSClient)
> --
> The request failed with HTTP status 404: Object Not Found.
> (Microsoft.SqlServer.Management.UI.RSClient)
> I have visual studio 2005 on the machine (which I installed after the
> SQL Server install) and have .NET Framework version 2.0.50727.42.
> The OS is windows XP Professional.
> Anyone know what I will need to do to connect to the server?
I'm still having issues with this - if anyone can offer any insight it
would still be greatly appreciated.|||Hi,
I am also having the same problem,
and it seems that at least a few people in this newsgroup are having the
same problem.
Somebody please help us with this!|||I resolved the issue, at least for my machine. My IIS is ver. 5.1, and the
URLScan did not allow POST verb. Once I listed POST as an allowed verb in
URLScan.ini, I could successfully connect to the report manager.
For anybody having problem, as below, I suggest you check your URLScan
settings.
The problems are :
1) When you navigate to http://<localhost>/<reports>, you get, "The attempt
to connect to the report server failed. Check your connection information
and that the report server is a compatible version.
(Microsoft.SqlServer.Management.UI.RSClient)".
2) You cannot connect to your reporting services instance through the
Management Studio.

No comments:

Post a Comment