Hello,
uninstalling and reinstalling didn't work for me - but the Microsoft Support could give me the solution. Here it is:
---------
When upgrading SQL Reporting Services to a newer version, there machine be multiple instances configured in WMI which can lead to AX reporting Service failures. Detected Detected
Please verify the SQL Reporting Services WMI configuration with a tool like wbemtest, for more information on deleting WMI entries see the Public Content link below. Completed
ErrorAdditional Information
Information Collected: SRS Instance Version : v10
SRS Instance Server : SERVER1
SRS Instance Namespace : ROOT\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER
SRS Instance PATH :\\SERVER1\ROOT\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER:__NAMESPACE.Name="v10"
InformationalMore Information
Description: Reporting Services verification of instances on machine
Public Content: social.msdn.microsoft.com/.../c578052c-9d67-4141-93ef-49b9139d2678
Action Plan
==============
In order to solve this issue , we should follow these steps , please try to follow them but if you have any problem just let me know and I will establish a remote session and follow the procedure with you.
1. Run command wbemtest
2. Click "Connect"and connect to “ROOT\Microsoft\SqlServer\ReportServer”(type this path in the Namespace textbox)
3. After connecting to the name space, click "Query" to query “SELECT * from __namespace”. There SHOULD be one data in the record window (while the server only have one RS instance).
4. Double-click the record, in the new properties windows, get the path value such as “\\<server>\ROOT\Microsoft\SqlServer\ReportServer:__NAMESPACE.Name="RS_MSSQLSERVER" ”
5. Now, close all sub dialogs, and then re-connect to “ROOT\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER”. "RS_MSSQLSERVER" is the Namespace.Name in step4
6. Query “SELECT * from __namespace” again.
7. Repeat step4,5, we will get the new path “ROOT\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10”
8. Repeat step2 to 7 until there is no record in the Query result dialog. Finally, the path is \\server\ROOT\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\admin
If we can't get the final path \\server\ROOT\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\admin, it means the Reporting Services WMI provider is not installed correctly. If we can get to that path, there might be an orphaned instance of SSRS. Go back to step 2 and do these steps:
9. Click "Connect"and connect to “ROOT\Microsoft\SqlServer\ReportServer”
10. After connecting to the name space, click "Query" to query “SELECT * from __namespace”. If there is more than 1 record, and you have only 1 SSRS instance installed (or at least you think you have), click on all the other records, and hit "Delete" button.
11. Now restart SSRS Configuration Manager and you should connect without problems.
Thomas
