I installed Clienr Status Reporting, but it not work. On sms database i granted all priveleges, i try to change account setting but in log i still see next message ********** Logging Initialized for .\logs\chService.log ********** <11/3/2010 3:35:09 PM> Log Created <11/3/2010 3:35:09 PM> Service Starting <11/3/2010 3:35:10 PM> Load Settings <11/3/2010 3:35:10 PM> Done Loading <11/3/2010 3:35:10 PM> Invalid SQL error - Could not find stored procedure 'CH_UpdateSettings'. <11/3/2010 3:35:10 PM> Failed to update settings in database <11/3/2010 3:35:10 PM> Load Settings for Daily Task <11/3/2010 3:35:10 PM> Load Settings for Pulse <11/3/2010 3:35:10 PM> Load Settings Ping <11/3/2010 3:35:10 PM> Done Loading Daily Task Settings <11/3/2010 3:35:10 PM> Done Loading Pulse Settings <11/3/2010 3:35:10 PM> Done Loading Ping Settings <11/3/2010 3:35:10 PM> Start to run daily task <11/3/2010 3:35:10 PM> Schedule is Active Today <11/3/2010 3:35:10 PM> Schedule is Active Today <11/3/2010 3:35:10 PM> Invalid SQL error - Could not find stored procedure 'CH_SyncClientSummary'. <11/3/2010 3:35:10 PM> Pulse is not configured to run on schedule. <11/3/2010 3:35:10 PM> Ping is not configured to run on schedule. <11/3/2010 3:35:10 PM> Failed to sync client summary in database <11/3/2010 3:35:10 PM> Invalid SQL error - Could not find stored procedure 'CH_UpdateCurrentHealth'. <11/3/2010 3:35:10 PM> Failed to update current health in database <11/3/2010 3:35:10 PM> Invalid SQL error - Could not find stored procedure 'CH_UpdateHistoryCurrentState'. <11/3/2010 3:35:10 PM> Failed to update history current state in database <11/3/2010 3:35:10 PM> Invalid SQL error - Could not find stored procedure 'CH_CleanAgedRecords'. <11/3/2010 3:35:10 PM> Failed to clean aged records in database <11/3/2010 3:35:10 PM> Invalid SQL error - Could not find stored procedure 'CH_UpdateInactiveClients'. <11/3/2010 3:35:10 PM> Failed to update inactive clients in database <11/3/2010 3:35:10 PM> Daily Task is finished. All of these stored procedures i can see in database. How i can resolve this problem?

Are you running the SQL server on a remote box?Kent Agerlund | http://scug.dk/ | The Danish community for System Center products

yes, i have separate sql server. I give all rights for Client Status Reporting server account.

there is a hotfix you need to install on the SCCM server - sccm2007-r2-kb959975-x86-enuKent Agerlund | http://scug.dk/ | The Danish community for System Center products

It didn't resolve problem. I use default instance and in description in this hotfix: This problem does not occur if you configure the default istance of SQL Server 2005 as the Client Status Reporting database.

Are you running SCCM on W2K8 ? If so, try to run the CSR Wizard with elevated privileges (run as administrator). I had the same problem and it worked for me.Olivier

Are you running SCCM on W2K8 ? If so, try to run the CSR Wizard with elevated privileges (run as administrator). I had the same problem and it worked for me.Olivier

Are you running SCCM on W2K8 ? If so, try to run the CSR Wizard with elevated privileges (run as administrator). I had the same problem and it worked for me. Olivier Yes, i ran it on w2k8 with elevated privileges, but this not solve problem. I try to setup this component on another sccm box. On another box it work.