October 22, 2008 at 1:01 pm
I have a SQL Server 2005 server running reporting services. I have 2008 Management studio on my workstation. When I try to connect to the 2005 reporting services I get the error below. It connects fine from Management Studio 20005.
TITLE: Connect to Server
------------------------------
Cannot connect to SS013.
------------------------------
ADDITIONAL INFORMATION:
Report Server WMI Provider error:
Invalid namespace (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
Invalid namespace (System.Management)
------------------------------
Program Location:
at Microsoft.ReportingServices.WmiProvider.WmiProviders.GetInstance(String machineName, String instanceName, RSWmiNamespaces rsNamespace, ConnectionOptions connOptions, ObjectGetOptions getOptions)
at Microsoft.ReportingServices.WmiProvider.WmiProviders.GetReportServerInstance(String machineName, String instanceName, ConnectionOptions connOptions, ObjectGetOptions getOptions)
at Microsoft.ReportingServices.WmiProvider.WmiProviders.GetReportServerInstance(String machineName, String instanceName)
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.GetRSConnectionObject(Boolean ensureOpenConnection)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.ProceedWithConnection(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.Microsoft.SqlServer.Management.UI.ConnectionDlg.IServerType.ProceedWithConnection(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
===================================
Invalid namespace (System.Management)
------------------------------
Program Location:
at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at Microsoft.ReportingServices.WmiProvider.WmiProviders.GetInstance(String machineName, String instanceName, RSWmiNamespaces rsNamespace, ConnectionOptions connOptions, ObjectGetOptions getOptions)
October 22, 2008 at 2:54 pm
what are the SQL 2005 and 2008 versions?
It should work fine
Can you connect to the SSRS 2005 using the "Reporting Service Manager" in your SQL 2008 Program Menu\Configuration shortcut?
October 22, 2008 at 5:07 pm
You cannot connect to SQL Server 2005 Reporting Services from the 2008 client tools. You need to use the 2005 client tools.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
November 13, 2009 at 12:35 pm
December 15, 2009 at 1:00 pm
I was using
http://servername/reportserver but it doesn't give you the home folder. Are there any works around?
Thanks.
December 15, 2009 at 2:31 pm
khau tinh (12/15/2009)
I was usinghttp://servername/reportserver but it doesn't give you the home folder. Are there any works around?
Thanks.
Refer to this thread w/ Jonathan Kehayias and Prash Shirolkar -
I do not believe you are doing anything wrong, however the absence of the Home node in SSMS 2008 does not depend on whether SSMS 2008 connects via WMI or not; rather that this node has been removed from SSMS 2008 altogether. Unfortunately, this is a breaking change in SSMS 2008, listed under the feature SQL Server Management Studio @ http://msdn.microsoft.com/en-us/library/ms143380.aspx. Currently, we do not have any plans to add the Home node back into SSMS 2008.
Prash Shirolkar
-----------------------------------------------------------------------------------------------
Thanks for the response, but connecting to the http endpoint for the web service doesn't provide the same functionality. I can see Jobs, Security and Shared Schedules only when I connect to the webservice, whereas when I connect to the instance name, I get Home, Security and Shared Schedules. This is on RS version 9.0.3042 from the RTM SQL 2008 SSMS. If I use the 2005 SSMS and connect to the webservice, I do get the same exact thing as connecting to the instance name directly.
I have tried it both as http://RSServerName/reportserver/ReportService2005.asmx and http://RSServerName/reportserver/, and I get the same result. I can't see the Home folder which is what I need to see. I can manage all of this from the web address for the Report Server, so ther are plenty of work arounds, but I don't think it is far fetched to expect that SSMS would be backwards compatible for something like this. I'll just change my migration plans around so that I am only split between 2005 and 2008 for a short time while I am upgrading, but I expect that this will be reported again by others as they begin to upgrade from 2005 to 2008.
If I am doing something wrong with how I am connecting to the webservice, please let me know. Otherwise I'll accept that it is closed.
Jonathan Kehayias
Tommy
Follow @sqlscribeMarch 8, 2011 at 6:26 pm
I have just experienced this error and it turned out to be some kind of disk corruption. We had a dead disk in a RAID 5 array. After replacement and RAID rebuild, SSRS still didn't wrked. SO we restarted SQL Server. No luck. Reboot resolved it.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply