Cannot connect to SSRS from SSMS

%3CLINGO-SUB%20id%3D%22lingo-sub-1601947%22%20slang%3D%22en-US%22%3ECannot%20connect%20to%20SSRS%20from%20SSMS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601947%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20install%20SSRS%202017%20Reporting%20Service%20and%20have%20configure%20Report%20Server%20from%20Report%20Server%20Configuration%20Manager.%26nbsp%3B%3C%2FP%3E%3CP%3EReport%20Server%20Status%20is%20Started%2C%20mode%20is%20Native.%3C%2FP%3E%3CP%3EI%20have%20setup%20all%20necessary%20setting%20like%20Service%20account%2C%20Web%20Service%20URL%2C%20Database%2C%20and%20Web%20Portal%20URL.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20access%20Web%20portal%20URL%20from%20my%20browser%2C%20but%20I%20cannot%20connect%20through%20SSMS.%3C%2FP%3E%3CP%3EMy%20SSMS%20version%20is%2015.0.18338.0%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20at%20Registered%20Server%2C%20I%20can%20see%20the%20Reporting%20Services%20with%20the%20same%20name%20as%20the%20one%20set%20in%20Report%20Server%20Configuration%20Manager.%20But%20still%20every%20time%20I%20want%20to%20connect%2C%20after%20key%20in%20the%20Server%20name%20-%26gt%3B%20%3CMYSERVERNAME%3E%5CReportServer2017%20(which%20is%20my%20report%20server%20name%20as%20in%20Configuration%20Manager)%2C%20eror%20saying%20Cannot%20connect%20to%20%3CMYSERVERNAME%3E%5CReportServer2017%2C%20REporting%20Services%20instance%20could%20not%20be%20found.%3C%2FMYSERVERNAME%3E%3C%2FMYSERVERNAME%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20can%20advice%20what%20is%20wrong%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1678007%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20connect%20to%20SSRS%20from%20SSMS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1678007%22%20slang%3D%22en-US%22%3E%3CP%3EDifferent%20to%20database%20engine%20you%20have%20to%20use%20the%20%3CSTRONG%3EReport%20Server%20URL%3C%2FSTRONG%3E%20as%20Servername%2C%20in%20your%20case%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehttp%3A%2F%2Fmachinename%2Freportserver_ReportServer2017%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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 ?

 

1 Reply

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

 

http://machinename/reportserver_ReportServer2017