When I try to connect to my reporting services server (SQL Server 2005) from my local machine, SQL Server 2014 I get the error message below
Invalid Namespace (System.Management)
But when I RDP into my reporting services server and connect to reporting services there, everything is fine.
There is nothing wrong with the reporting services.
Is there a way to connect to SQL Server 2005 Reporting Services from a SSMS 2014?
Best Answer
I have the same problem except my Reporting Service is 2008 R2.
Anyway I have SSMS 2014 on the server where Reporting Service is installed and get the same error.
I have installed SSMS 2008 R2 and straight away it works.
So you must have same version SSMS as Reporting service.
And here is explanation:
In Reporting Services, the namespace for SSRS 2014 is root\Microsoft\SqlServer\ReportServer\RS_\v12\Admin while the namespace for SSRS 2012 is root\Microsoft\SqlServer\ReportServer\RS_\v11\Admin.