SSRS 2008 R2 Connection via SSMS

Dear All

I am faced with an issue in which is starting to fry my brain cells.

We have just installed a new instance of SSRS 2008 R2 (std) onto a Windows 2008R2 box. I have gone through all the Config setup for SSRS, UAC, Firwall setting, permissions etc etc.

My problem is that I am unable to connect to SSRS via SSMS (Error below). I can connect to the browser based portals (http://.../Reports and http://.../ReportServer).

We have also tried the SSMS client on the SSRS server to no avial.

Thanks JL

 Cannot connect to localhost.
 Unable to connect to the server at localhost. 
 The specified URL might not be valid or there 
 might be a problem with the report server version or configuration. 
 Specify a different URL, or contact your server administrator to verify that the report server 

 runs SQL Server 2008 or later. Additionally, if you are trying to connect to a 
 SharePoint-integrated report server, verify that SharePoint is installed on the server and that 
 the report server uses SharePoint integrated mode. (Microsoft.SqlServer.Management.UI.RSClient)
 Program Location:
    at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection()
    at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.GetRSConnectionObject(Boolean ensureOpenConnection)
    at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.ProceedWithConnection(UIConnectionInfo ci)
    at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.Microsoft.SqlServer.Management.UI.ConnectionDlg.IServerType.ProceedWithConnection(UIConnectionInfo ci)
    at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
more ▼

asked Sep 13, 2010 at 04:24 AM in Default

avatar image

10.9k 27 37 37

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

Just thought I would update my question with the resolution...

The problem we had was due to our internal proxy settings within Internet explorer. As SSRS was connecting the reports URL the proxy was trying to authenticate the user.

Disabling the use of the proxy in IE or adding the SSRS URL to the PAC file fixed this issue.

more ▼

answered Sep 14, 2010 at 01:20 AM

avatar image

10.9k 27 37 37

(comments are locked)
10|1200 characters needed characters left

Is SSRS installed as the default instance? You should be able to connect to SSRS just like you would a regular server, just chose SSRS and type the name of your server. If you have multiple SSRS instances then servername\instance name.

more ▼

answered Sep 13, 2010 at 04:33 AM

avatar image

40.9k 39 94 168

It is the default instance on the server (therefore the browsers service is not required)... I am setup as an admin to the site/server.

It says "localhost" in the error because I was connected to the server @ the time... Also tried "." and "servername".

Sep 13, 2010 at 04:39 AM sp_lock
(comments are locked)
10|1200 characters needed characters left

Every reporting instance I have I am able to open SSMS, click connect, chose Reporting Services and then type the name of my server and the instance name if I have more than one instance of Reporting Services installed. Are you launching SSMS from the server where SSRS is installed or from your workstation? If from your workstation are you using the SSMS version of the server you are trying to connect to?

more ▼

answered Sep 13, 2010 at 05:52 AM

avatar image

40.9k 39 94 168

@Trad I have tried both and yes they are the exacted same version. Thanks

Sep 13, 2010 at 07:10 AM sp_lock

What is the exact error that is displayed when you try from the console of the server to connect to SSRS through SSMS?

Sep 13, 2010 at 07:12 AM Tim

@Trad.. The error is in my intial post. Cheers

Sep 13, 2010 at 07:19 AM sp_lock
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 13, 2010 at 04:24 AM

Seen: 5133 times

Last Updated: Sep 13, 2010 at 04:24 AM

Copyright 2018 Redgate Software. Privacy Policy