Wednesday, July 02, 2008
An unknown error has occurred in the WMI Provider. Error code 80040219
If you are working with Reporting service and do see couple of Instance ID on SQL 2005. Most probably you might had deleted, moved or rename any of those Instance ID.
Ex: If you see MSSQL.1 and renamed to MSSQL.3 to make Reporting service configration Manager to show only one instance. This error will show up...
Refer to below link to help resolve this issues.
http://support.microsoft.com/kb/909967
http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=354408&SiteID=1
How To Create a User-Defined Service
To create a Windows NT user-defined service, perform the following steps:
1. At a MS-DOS command prompt(running CMD.EXE), type the following command:
path\INSTSRV.EXE My Service path\SRVANY.EXE
where path is the drive and directory of the Windows NT Resource Kit (i.e., C:\RESKIT) and My Service is the name of the service you are creating.
Example: C:\Program Files\Resource Kit\Instsrv.exe Notepad C:\Program Files\Resource Kit\Srvany.exe
NOTE: To verify that the service was created correctly, check the registry to verify that the ImagePath value under
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\service name
is set to point to SRVANY.EXE. If this is not set correctly, the service will stop shortly after it starts and return an Event ID 7000 "The service name failed to start."
WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.For information about how to edit the registry, view the "Changing Keys And Values" online Help topic or the "Add and Delete Information in the Registry" and "Edit Registry Data" online Help topics in Registry Editor.NOTE: You should back up the registry before you edit it.
2. Run Registry Editor (Regedt32.exe)and locate the following subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\
3. From the Edit menu, click Add Key. Type the following and click OK:
Key Name: Parameters
Class :
4. Select the Parameters key.
5. From the Edit menu, click Add Value. Type the following and click OK:
Value Name: Application
Data Type : REG_SZ
String :\
where\ is the drive and full path to the application executable including the extension (i.e., C:\WinNT\Notepad.exe)
6. Close Registry Editor.
By default, a newly created service it configured to run Automatically when the system is restarted. To change this setting to Manual, run the Services applet from Control Panel and change the Startup value to Manual. A service set to Manual can be started in one of several ways:
- From the Services applet in Control Panel
- From a MS-DOS command prompt, type the following:
NET START
- Use the Sc.exe utility from the Resource Kit. Type the following from a MS-DOS command prompt:
\Sc.exe start
where is the drive and directory of the Windows NT Resource Kit (i.e., C:\Reskit).
Ref: http://support.microsoft.com/kb/137890#appliesto
1. At a MS-DOS command prompt(running CMD.EXE), type the following command:
path\INSTSRV.EXE My Service path\SRVANY.EXE
where path is the drive and directory of the Windows NT Resource Kit (i.e., C:\RESKIT) and My Service is the name of the service you are creating.
Example: C:\Program Files\Resource Kit\Instsrv.exe Notepad C:\Program Files\Resource Kit\Srvany.exe
NOTE: To verify that the service was created correctly, check the registry to verify that the ImagePath value under
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\service name
is set to point to SRVANY.EXE. If this is not set correctly, the service will stop shortly after it starts and return an Event ID 7000 "The service name failed to start."
WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.For information about how to edit the registry, view the "Changing Keys And Values" online Help topic or the "Add and Delete Information in the Registry" and "Edit Registry Data" online Help topics in Registry Editor.NOTE: You should back up the registry before you edit it.
2. Run Registry Editor (Regedt32.exe)and locate the following subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\
3. From the Edit menu, click Add Key. Type the following and click OK:
Key Name: Parameters
Class :
4. Select the Parameters key.
5. From the Edit menu, click Add Value. Type the following and click OK:
Value Name: Application
Data Type : REG_SZ
String :
where
6. Close Registry Editor.
By default, a newly created service it configured to run Automatically when the system is restarted. To change this setting to Manual, run the Services applet from Control Panel and change the Startup value to Manual. A service set to Manual can be started in one of several ways:
- From the Services applet in Control Panel
- From a MS-DOS command prompt, type the following:
NET START
- Use the Sc.exe utility from the Resource Kit. Type the following from a MS-DOS command prompt:
where
Ref: http://support.microsoft.com/kb/137890#appliesto
How to change service path for any Windows services
This article contains information about editing the registry. Before you edit the registry, make sure you understand how to restore it if a problem occurs. Make sure to backup registry before making any changes
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\service name
is the path where one can find all windows services running.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\service name
is the path where one can find all windows services running.
rsRPCError; The report server installation is not initialized
Reporting Services Error
The report server installation is not initialized
Check the link for more details
Also best practice to start with troubleshoot is to make sure remote SCOM server have full privilege on ReportsServer and ReportServerTempDB database.
After trying many options the one that work was to uninstall and reinstall Reporting Service. Below are the services
1. Uninstall Reporting service from Add and remove program. Select Microsoft SQL server and click Change button. Then select SQL => Reporting services
2. Reboot the box after uninstallation
3. Install Report Service from SQL 2005 setup.exe file and select only Reporting Services. Click Advance button and make sure the Path and Entire feature will be installed on local hard drive.
4. Install SQL SP2 if its not embaded in you previous setup.exe file.
5. Reboot SQL 2005 server box.
6. Configure "Reporting Service Configuration" under All Programs => Microsoft SQL Server 2005 => Configuration Tools.
The report server installation is not initialized
Check the link for more details
Also best practice to start with troubleshoot is to make sure remote SCOM server have full privilege on ReportsServer and ReportServerTempDB database.
After trying many options the one that work was to uninstall and reinstall Reporting Service. Below are the services
1. Uninstall Reporting service from Add and remove program. Select Microsoft SQL server and click Change button. Then select SQL => Reporting services
2. Reboot the box after uninstallation
3. Install Report Service from SQL 2005 setup.exe file and select only Reporting Services. Click Advance button and make sure the Path and Entire feature will be installed on local hard drive.
4. Install SQL SP2 if its not embaded in you previous setup.exe file.
5. Reboot SQL 2005 server box.
6. Configure "Reporting Service Configuration" under All Programs => Microsoft SQL Server 2005 => Configuration Tools.
rsInvalidReportServerDatabase
SQL Server Reporting Services
You get r"sInvalidReportServerDatabase" and "The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.8.54'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase) " error when trying to access http://localhost/reportserver
Solution:
Try to apply/re-apply SP2 to your reporting services installationsince the ReportServer database you are pointing to is at an SP2 level(C.0.8.54) whereas the Reporting Services instance that is trying to usethat database is at an RTM level and therefore looking for an RTM leveldatabase (C.0.8.40).
Also make sure if you got full access permissions on "Operations Manager 2007 WebConsole" or "Default Web Site" folder under IIS => local computer => Web Site (folder).
You get r"sInvalidReportServerDatabase" and "The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.8.54'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase) " error when trying to access http://localhost/reportserver
Solution:
Try to apply/re-apply SP2 to your reporting services installationsince the ReportServer database you are pointing to is at an SP2 level(C.0.8.54) whereas the Reporting Services instance that is trying to usethat database is at an RTM level and therefore looking for an RTM leveldatabase (C.0.8.40).
Also make sure if you got full access permissions on "Operations Manager 2007 WebConsole" or "Default Web Site" folder under IIS => local computer => Web Site (folder).
Subscribe to:
Posts (Atom)