Cannot connect to Reporting Services
I cannot connect to Reporting Services from Management Studio. The error message I get is: TITLE: Connect to Server ------------------------------ Cannot connect to <SERVERNAME>\ReportServer. ------------------------------ ADDITIONAL INFORMATION: Report Server WMI Provider error: Invalid namespace (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------ Invalid namespace (System.Management) ------------------------------ BUTTONS: OK This appears to be a WMI issue, but when I checked on the SQL server machine, the WMI service is running and the firewall is turned off. I ran a few tests and found that the WMI has its ReportServer WMI data at \\<SERVERNAME>\root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\admin:MSReportServer_ConfigurationSetting" (I can find this info using a small console app I had to write). Is this the correct place for the WMI info? Version info: Microsoft SQL Server Management Studio 10.0.2531.0 Microsoft Analysis Services Client Tools 10.0.1600.22 Microsoft Data Access Components (MDAC) 6.1.7600.16385 Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 8.0.7600.16385 Microsoft .NET Framework 2.0.50727.4952 Operating System 6.1.7600 This is very strange as this exact issue has appeared on the forums but with a SQL2005 management studio connecting to a SQL2008 server, but I am using SQL2008 standard edition on both the client and server. Any ideas?
September 15th, 2010 11:26am

https://connect.microsoft.com/SQLServer/feedback/details/361680/sql-2008-management-studio-and-sql-2005-reporting-services?wa=wsignin1.0Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
September 15th, 2010 12:22pm

Thanks for the reply, but I have already seen that bug - and its not related. That one is due to SQL2008 MS being unable to connect to an SQL2005 instance by design, and my problem is using a 2008 management studio with SSRS SQL2008.
September 15th, 2010 2:53pm

Hi zedhex1, The WMI namespace "\\<SERVERNAME>\root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\admin:MSReportServer_ConfigurationSetting" is right. However, it is used for default instance. In this case, are you using named instance? If so, the WMI should be "\\<SERVERNAME>\root\Microsoft\SqlServer\ReportServer\RS_<instance name>\v10\admin:MSReportServer_ConfigurationSetting". So, please make sure the server and instance is correct while connecting to SQL Server Reporting Services from SQL Server Management Studio. Thanks, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
September 21st, 2010 12:34pm

Found the solution : I was connecting via a proxy. If I disabled my proxy, and could connect using the servername as normal (but this meant I cannot connect to the internet). If I used the proxy, I can connect via http://<ServerName>/reportserver Unfortunately, many of the tools I use cannot with report services via http, so i now have to persuade our sysadmins to add exceptions to our proxy.pac file to allow me to access reporting services. This is an interesting gotcha, in that the error message "Invalid WMI namespace" had absolutely nothing to do with the cause of the problem, and has caused several days of confusion. Writing good error messages is hard.
September 28th, 2010 5:36pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics