The MSSLogToDatabase tool does not recognize a SQL Server 2005 Reporting Services host in Microsoft Speech Server 2004 (914824)

WORKAROUND

To work around this problem, create a static instance of the SQL Server 2000 Reporting Services WMI namespace on the computer that is running SQL Server 2005 Reporting Services.

Note This workaround does not affect the SQL Server 2005 Reporting Services installation.

To do this, follow these steps:

1. On the computer that is running SQL Server 2005 Reporting Services, create a text file that contains the following code.

   #pragma namespace("\\\\.\\root\\Microsoft")
   
   instance of __Namespace
   {
       Name = "SqlServer";
   };
   
   #pragma namespace("\\\\.\\root\\Microsoft\\SqlServer")
   
   instance of __Namespace
   {
       Name = "ReportingServices";
   };
   
   #pragma namespace("\\\\.\\root\\Microsoft\\SqlServer\\ReportingServices")
   
   instance of __Namespace
   {
       Name = "v8";
   };
   
   #pragma namespace("\\\\.\\root\\Microsoft\\SqlServer\\ReportingServices\\v8")
   
   class MSReportServer_ConfigurationSetting
   {
   	[key] string VirtualRoot;
   };
   
   instance of MSReportServer_ConfigurationSetting
   {
       VirtualRoot = "http://localhost/reportserver";
   };

2. Save this file as the C:\CreateSql2000RS.mof file.
3. Click Start, click Run, type the following command, and then click OK:

   Mofcomp C:\CreateSql2000RS.mof

   Note The MSSLogToDatabase tool works as expected.

Removal

When you no longer want to use the MSSLogToDatabase tool to import MSS 2004 log data, you may want to delete the instance of the WMI namespace that you created in this workaround. To do this, follow these steps on the computer that is running SQL Server 2005 Reporting Services:

1. Create a text file that contains the following code.

   #pragma namespace("\\\\.\\root\\Microsoft\\SqlServer\\ReportingServices")
   #pragma deleteinstance("__Namespace='V8'", NOFAIL)

2. Save this file as the C:\DeleteSql2000RS.mof file.
3. Click Start, click Run, type the following command, and then click OK:

   Mofcomp C:\DeleteSql2000RS.mof

Note Do not follow these steps if a valid instance of SQL Server 2000 Reporting Services is present on the computer.