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.
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:
It doesn't work as well.
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:
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... <(-_-")>
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
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!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With