Cannot connect to Reporting Services with Managment Studio

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Cannot connect to Reporting Services with...

Cannot connect to Reporting Services with Managment Studio

Rate Topic

Display Mode

Topic Options

Author

Message

johnmcp

Posted Monday, November 19, 2012 8:49 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:52 AM
Points: 46, Visits: 209

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

sql.com

Posted Tuesday, November 20, 2012 8:43 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 22, 2013 8:31 AM
Points: 172, Visits: 549

a silly question but is the service started?
i like to start from the bottom Wink

-------------------------------------------
I'm not afraid of storms, for I'm learning to sail my ship

Post #1386965

johnmcp

Posted Tuesday, November 20, 2012 8:57 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:52 AM
Points: 46, Visits: 209

No better place to start BigGrin

The service is definitely started, I can connect through the browser and run reports no problem.

Post #1386981

sql.com

Posted Wednesday, November 21, 2012 1:32 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 22, 2013 8:31 AM
Points: 172, Visits: 549

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

johnmcp

Posted Friday, November 23, 2012 3:56 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:52 AM
Points: 46, Visits: 209

I just tried with the URL, still no luck Sad

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

sql.com

Posted Friday, November 23, 2012 4:03 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 22, 2013 8:31 AM
Points: 172, Visits: 549

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

johnmcp

Posted Friday, November 23, 2012 5:31 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:52 AM
Points: 46, Visits: 209

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

johnmcp

Posted Monday, November 26, 2012 2:00 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:52 AM
Points: 46, Visits: 209

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

Joie Andrew

Posted Friday, January 18, 2013 8:50 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:23 AM
Points: 553, Visits: 1,032

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 »

Permissions