x

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

sp_lock gravatar image

sp_lock
9.2k 25 28 31

(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

sp_lock gravatar image

sp_lock
9.2k 25 28 31

(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

Tim gravatar image

Tim
36.4k 38 41 139

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

Tim gravatar image

Tim
36.4k 38 41 139

@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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x587
x555
x126

asked: Sep 13, 2010 at 04:24 AM

Seen: 4360 times

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