Joining the report server to the web farm of the local instance failed

  • the report database is SQL2005, and 2 report servers 2005 are connected, when i try to initialize a 2008 RS server i receive the following message

    ReportServicesConfigUI.WMIProvider.WMIProviderException: No report servers were found on the specified machine. ---> System.Management.ManagementException: Invalid namespace

    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 ReportServicesConfigUI.WMIProvider.RSInstances.GetInstances(String machineName)

    --- End of inner exception stack trace ---

    at ReportServicesConfigUI.WMIProvider.RSInstances.GetInstances(String machineName)

    at ReportServicesConfigUI.WMIProvider.RSInstances.GetInstance(String machineName, String instanceName)

    at ReportServicesConfigUI.Panels.ClusterManagementPanel.ConfigureWebFarm(Object sender, RSReportServerInfo[] rsInfos)

    Since RS2008 doesnt use IIS, is it possible to add the server to an RS 2005 farm? This is a development farm.

  • I think you can use IIS it is just not required but you cannot use SQL Server 2005 WMI and SQL Server 2008 WMI together so you need to either upgrade and change all your code in 2005 to 2008 or run either 2005 or 2008. Check below for details about WMI which will also prevent you from connecting to SQL Server 2005 Reporting Services in SMS.

    http://msdn.microsoft.com/en-us/library/ms143380.aspx

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply