asked
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()
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.
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.
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?
