'SQL Reporting - No report servers were found
I am trying to configure the SQL Reporting Services (local 2016 installation) but get this exception when I open the configuration manager and enter my host name:
I have installed the services and they run:
I also checked WBEMTEST and got the instance (with RS_
in front and _
coded as _5f
, which is exactly what I would expect):
I can connect to it via SSMS:
I already checked SO and Google, made sure TCP/IP is enabled, tried to repair the SQL Server... I have no more ideas and would be very thankful if someone has already solved a similar issue.
UPDATE
I uninstalled the reporting services and installed them again. Now I am not able to connect to the services via SSMS. And still not able to configure them...
Solution 1:[1]
After two days spent on this, deinstallation of everything possible incl. all other SQL Server versions, multiple restarts, and so on, I finally found a solution!
I checked all folders
C:\Program Files (x86)\Microsoft SQL Server\xxxx\Tools\Binn
for RSConfigTool.exe and started (despite deinstalls and only one result in the search / start menu!) multiple configuration managers until I found this one:
Here I was finally able to configure the reporting services.
Solution 2:[2]
Well, I found a solution based on hints above. Search for different versions. In my case the exe with the newest file date worked.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | Antiohia |
Solution 2 | Alex Martin |