Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSMS can't connect to SSRS

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... <(-_-")>

like image 471
Max S. Avatar asked Jan 03 '23 16:01

Max S.


2 Answers

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

like image 68
DeanOC Avatar answered Jan 11 '23 03:01

DeanOC


Victory! I found the issue. Firstly, I haven't completed the setup... So in the "Report Server Configuration Manager", I have omitted the "Database" tab and the setup it entails.

Although, at this point, I was able to access the Report Manager URL through my browser, I was still unable to connect to the "Reporting Services" through SSMS. And here's how I solved it:

I noticed that my Virtual Directory name in "Web Services URL" as well as "Web Portal URL" were identical, so assuming that this was possibly a cause for the error I changed them to different names: one was remained "SSRS", the other was changed to "reports". Bang!

like image 34
Max S. Avatar answered Jan 11 '23 05:01

Max S.