Cannot connect to SSRS from SSMS

Copper Contributor

Hello,

 

I just install SSRS 2017 Reporting Service and have configure Report Server from Report Server Configuration Manager. 

Report Server Status is Started, mode is Native.

I have setup all necessary setting like Service account, Web Service URL, Database, and Web Portal URL.

 

I can access Web portal URL from my browser, but I cannot connect through SSMS.

My SSMS version is 15.0.18338.0

 

Looking at Registered Server, I can see the Reporting Services with the same name as the one set in Report Server Configuration Manager. But still every time I want to connect, after key in the Server name -> <Myservername>\ReportServer2017 (which is my report server name as in Configuration Manager), eror saying Cannot connect to <Myservername>\ReportServer2017, REporting Services instance could not be found.

 

Anyone can advice what is wrong ?

 

3 Replies

Different to database engine you have to use the Report Server URL as Servername, in your case

 

http://machinename/reportserver_ReportServer2017

@olafhelper I had the same issue and tried to connect with the URL http://servername/reportserver_PBIRS (Where PBIRS is the instance name for my Reporting server). I also tried http://machinename.domain.com/reportserver but no luck. I am able to access the URL from the browser but not through SSMS. 

Report Server Mode: Native

Instance ID: PBIRS

 

Am I missing anything?

@VoltesDev Were you able to resolve this issue?