Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cannot connect to Reporting Services with Managment Studio Expand / Collapse
Author
Message
Posted Monday, November 19, 2012 8:49 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 4:30 AM
Points: 58, Visits: 297
I've just set up a new instance of SSRS 2012 and I'm unable to connect to it through Management Studio. The error is:

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

Cannot connect to <server_name>.

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

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



It is a native report server. Reporting Services is running on a separate server to the reporting databases (but I doubt if this matters).
I can connect to the management URL fine. It is using SSL. Does this matter when connecting from Management Studio?
Any help appreciated.




Post #1386441
Posted Tuesday, November 20, 2012 8:43 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, August 23, 2014 9:39 AM
Points: 174, Visits: 573
a silly question but is the service started?
i like to start from the bottom



-------------------------------------------
I'm not afraid of storms, for I'm learning to sail my ship
Post #1386965
Posted Tuesday, November 20, 2012 8:57 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 4:30 AM
Points: 58, Visits: 297
No better place to start
The service is definitely started, I can connect through the browser and run reports no problem.
Post #1386981
Posted Wednesday, November 21, 2012 1:32 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, August 23, 2014 9:39 AM
Points: 174, Visits: 573
can you try in the ssms connection servername =
http://servername:port/ReportServer

i.e.

http://SSRSSSSQL007:80/ReportServer


-------------------------------------------
I'm not afraid of storms, for I'm learning to sail my ship
Post #1387275
Posted Friday, November 23, 2012 3:56 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 4:30 AM
Points: 58, Visits: 297
I just tried with the URL, still no luck

EDIT: My configuration had a https URL only. I added a http URL to the configuration and now I can connect with SSMS through this URL.
So it seems that my problem was related to using SSL. Unfortunately I can't leave the http URL so I still need to figure out why I can't connect using the SSL URL.
Post #1388109
Posted Friday, November 23, 2012 4:03 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, August 23, 2014 9:39 AM
Points: 174, Visits: 573
you wrote Reporting Services is running on a separate server ....

can you check C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles

and the application event viewer for any clues


-------------------------------------------
I'm not afraid of storms, for I'm learning to sail my ship
Post #1388111
Posted Friday, November 23, 2012 5:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 4:30 AM
Points: 58, Visits: 297
I've got this warning message in the Application Log:

The value for UrlRoot in RSReportServer.config is not valid. The default value will be used instead.


There is nothing significant in the log files unfortunately.

Post #1388141
Posted Monday, November 26, 2012 2:00 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 4:30 AM
Points: 58, Visits: 297
I've had enough with this issue now, I've decided that I will just enable the http URL when I need to manage this server. That will have to do.
Post #1388466
Posted Friday, January 18, 2013 8:50 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, August 28, 2014 6:16 AM
Points: 709, Visits: 1,418
I know this thread is a little old, but I just came across it while troubleshooting a similar problem with SSRS 2008 R2. I could connect but would get an SSL error everytime I tried to view properties of anything.

In my scenario I realized that I could connect through SSMS to SSRS using SSL if I specified the entire report service URL.

ex: https://ssrsServer.yourcompany.org/ReportServer

Once that was done I connected fine and was able to view everything I expected to.


Joie Andrew
"Since 1982"
Post #1408955
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse