CODEWITHSUNDEEP
sql-serverreporting-services
Antiohia
Antiohia

Reputation: 1232

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:

enter image description here

I have installed the services and they run:

enter image description here

I also checked WBEMTEST and got the instance (with RS_ in front and _ coded as _5f, which is exactly what I would expect):

enter image description here

I can connect to it via SSMS:

enter image description here

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...

Upvotes: 0

Views: 6288

Answers (2)

Alex Martin
Alex Martin

Reputation: 196

Well, I found a solution based on hints above. Search for different versions. In my case the exe with the newest file date worked.

enter image description here

Upvotes: 0

Antiohia
Antiohia

Reputation: 1232

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:

enter image description here

Here I was finally able to configure the reporting services.

Upvotes: 4

Related Questions