SSMS can't connect to SSRS

sql-server reporting-services installation ssms ssms-2017
Max S. picture Max S. · Mar 15, 2018 · Viewed 8.5k times · Source

I'm learning the SQL server suite and just installed the Developer Edition. I included in my features the Integration and Analysis Services. As for the Reporting ones, I went back online (as indicated) and download/installed it.

Now, in my Start Menu / Microsoft SQL Server, I have the Reporting Services Configuration Manager. I click on it, a window pops asking me to indicate a server name and connect, which I do. At this point, everything seems to work and all is great and in the Current Report Server box, the status displays "active".

BUT! When I go into SQL Server Configuration Manager, it's not displayed.enter image description here

So I checked the Reporting Services Configuration Manager again in case if something changed there: negative, all the same and the status is still active. If I try to connect to it in SQL Server Management Studio, the "Reporting Services" server type appears and allows me to choose my server: enter image description here

It doesn't work as well. enter image description here

I'm starting to think I need to delete the entire SQL Server thing and go through it again, but does any1 have any better solutions? (if additionnal screenshots are needed, please let me know and I'll edit).

Thanks to all!

Edit

Thanks to DeanOC's answer below, I was able to connect, however, the SQL Server Configuration Manager still doesn't display the Reporting Service server and, in SSMS, when I click on any of the three possible crosshairs I get the following error:

enter image description here

EDIT 2

I found the following instructions https://support.microsoft.com/en-ca/help/956179/error-message-when-you-click-the-databases-node-in-sql-server-manageme

But my SSMS crashes every time I right click on the column... <(-_-")>

Answer

DeanOC picture DeanOC · Mar 15, 2018

In SSMS, when connecting to Reporting Services you have to specify the reporting services URL, not the name of the server hosting reporting services.

So in the 'Server name' box you need to type

http://MAX-PC/reportserver

Tip: if you are running SSMS on the server that is hosting reporting services, you can also use

http://localhost/reportserver

Related questions

SQL variable to hold list of integers

I'm trying to debug someone else's SQL reports and have placed the underlying reports query into a query windows of SQL 2012. One of the parameters the report asks for is a list of integers. This is achieved on the report …

Read More
Add alternating row color to SQL Server Reporting services report

How do you shade alternating rows in a SQL Server Reporting Services report? Edit: There are a bunch of good answers listed below--from quick and simple to complex and comprehensive. Alas, I can choose only one...

Read More
Tablix: Repeat header rows on each page not working - Report Builder 3.0

I have a tablix with lots of rows that span over multiple pages. I have set the Tablix property Repeat header rows on each page but this does not work. I read somewhere that this is a known bug in …

Read More