Issue: After the upgrade was done from SMS 2003 SP3 , we had a lot of “failure audit” events on the remote sql server (every 20 min). Warnings are logged for an account that wants to access the SQL server. (Account is specified as network access account and Push installation account) This is also logged in the ccm.log file on the SCCM 2007 SP1 primary site. We have identified a cause for the errors being logged in the CCM.LOG. It appears to occur due to the SMS_CLIENT_CONFIG_MANAGER key in the registry...(read more)

Read the complete post at http://scug.be/blogs/sccm/archive/2009/04/17/upgrading-an-sms-2003-sp3-with-remote-sql-server-to-sccm-2007-sp1-is-giving-a-lot-of-failure-audit-events-on-the-remote-sql-server.aspx