When you run a Scheduled Reporting Database Synchronization job (SQL Server Agent job) in the context of a proxy account in Microsoft SQL Server 2005, the SQL Server Agent job fails.
When this problem occurs, the following information is logged in the SQL Server Agent log:
2007-03-19 12:11:00 - !  SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000]
This problem is likely to occur if more than 10 SQL Server Agent jobs are running at the same time.
Note: The proxy account may be disabled if the system is configured to lock an account after a certain number of attempts to log on fail.
SQL Server Agent uses the CryptUnprotectData function to decrypt the password of the proxy account. However, the SQL Server Agent job fails if too many calls to the CryptUnprotectData function are made at the same time. This problem may occur if one of the following conditions is true: - More than 10 SQL Server Agent jobs are running at the same time. - Fewer than 10 SQL Server Agent jobs are running at the same time. However, the SQL Server Agent jobs have other operations that use the CryptUnprotectData function.
A fix for this issue was included in a supported hotfix made available from Microsoft and rolled into SQL Server 2005 Service Pack 3.
To obtain the supported hotfix and associated Article ID 938086, visit the following Microsoft Web site:
To obtain SQL Server 2005 SP3, visit the following Microsoft Web site: