SQL 2005 Reporting Services
I am having problems with getting reporting services to run, I am running XP SP2 with SQL 2005 Developer Edition. Here is some examples of the errors I am receiving. When I try to start the SQL Server Reporting Services, I get the following error The SQL Server Reporting Services (MSSQLSERVER) service on Local Computer started and stoped. Some services stoped automatically if they have no work to do, for example, the performance Logs and Alerts service. When I go to Start->All Programs->Microsoft SQL Server 2005->Confihuration Tools->Reporting Services Configuration I get the following error An unknown error has occurred in the WMI Provider, Error code 800706BA The event log says Failure Audit Login Failed for user NT AUTHORITY\NETWORK SERVICE. [CLIENT:<local machine>] Error Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database. (There is no database, I am unable to create one, and when I did the install of reporting services it did not create the database) Error Service Cannot be started MicrosoftServices Diagnostics Utilities UnknownUserNameExeption, The user or group name VirtualPC\ASPNET is not reconized. When I try to un-install reporting services I get the following error The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the Machine VirtualPC Error: 2147944122 (0x800706ba). I am really stuck, I cant even start over, it will not let me un-install, any help would be greatly appreciated. Joe
December 3rd, 2006 7:25pm

Try: 1. Uninstalling Reporting Services. 2. Since your SQL Server is on a named instance, install RS with files only option. 3. Opent the Configuration utility and create the database. If you have an existing report catalog database already installed, you can just generate and run the SQL Script to grant the right users permissions to that folder. 4. Make sure that the ASPNET user is a member of the SQLServer2005ReportingServicesWebServiceUser$NOR15279$MSSQLSERVER local Windows group. Make sure that the NT AUTHORITY\SYSTEM is a member of the SQLServer2005ReportServerUser$NOR15279$MSSQLSERVER local Windows groups. Grant these groups full access to the RS install folder, e.g. C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services
Free Windows Admin Tool Kit Click here and download it now
December 4th, 2006 8:10pm

I had a problem in WMI Control where Win32_Processor and Win32_OperatingSystem were "Access denied". Using the suggestion for the link SQL Server System Configuration Checker, i.e., http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/b924e835-b835-4883-8323-8b3600dfb0c1/ I found the following from greggnlisa: - Goto the start menu and LOCATE your command prompt (should be under Accessories). - Right click on it and select "Run as Administrator." - At the command prompt, type the following: net localgroup "Administrators" "NT Authority\Service" /add - And press Enter. - Reboot and you are done. I did not try the lengthy solutions proposed here and at http://social.msdn.microsoft.com/forums/en-US/Vsexpressinstall/thread/632ca405-1c38-405b-9ed3-01785c9f99d1/ because I noticed that they gave limited success, and they were time-consuming. This short solution might be worth trying before attempting the longer solutions. jameshnelson2003@yahoo.comjameshnelson2003@yahoo.com
June 23rd, 2011 7:49pm

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

Other recent topics Other recent topics