Home » .Net FrameworkRSS

Cannot connect to Reporting Services in SSMS using Servername

Hi,

Kindly help me as i can't connect to Reporting Services in SSMS using SERVERNAME but using URL(http://localhost/ReportServer) I can connect. Here is the error I received. Please advice.

TITLE: Connect to Server
------------------------------

Cannot connect to PERRYDUNDOC-W7.

------------------------------
ADDITIONAL INFORMATION:

Unable to connect to the server at SERVERNAME. 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)

------------------------------
BUTTONS:

OK
------------------------------

Thanks,
Perry

 

3 Answers Found

 

Answer 1

Hi Perry,

By default, the SQL server  Manager Studio(SSMS) uses the following way to connect  to a report  server instance:

Parse the server name(we typed) to get the ReportServer URL. This step uses the sql  Server Reporting Services(SSRS) WMI provider to get the URL. Use the got URL to connect to the report server.

There is a little different between the returned URL and the URL you used(http://localhost/ReportServer). The returned URL should be: http://<machinename>/ReportServer. This URL is same to the URL we can get from the "Web Service URL" in the Reporting Services configuration  Manager.

In this case, in order to troublehshoot the issue, please make sure we can open the report server by using http://<machinename>/ReportServer (from Internet Explorer). If so, we may be able to connect to the report server by using the server name too.
However, if we are not able to connect to the report server, please check the authentication configuration settings. If we are using Kerberos authentication, please make sure the Service Principal Name(SPN)s are registered correctly.

If you have any more questions, please feel free to ask.

Thanks,
Jin Chen


Jin Chen - MSFT
 

Answer 2

Hi Jin Chen,

 

I able to connect  using the following in IE.

1) http://<machinename>/ReportServer

2) http://localhost/ReportServer

can you please help  me on this --> please check the authentication configuration  settings.  If we are using Kerberos authentication, please make sure the Service Principal Name(SPN)s are registered correctly.

 

 

Thanks,

Perry

 

Answer 3

Hi Perry,

Do you use a proxy in the network? This means configuring the machine to use a proxy to access the network.

Thanks,
Jin Chen

 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter