SQL Agent job error: [298] SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000] during Scheduled Reporting Database Synchronization Job
Article ID: 152438
Updated On:
Products
Issue/Introduction
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 - ! [298] 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.
Cause
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.
Resolution
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:
http://support.microsoft.com/kb/938086
To obtain SQL Server 2005 SP3, visit the following Microsoft Web site:
http://go.microsoft.com/fwlink/?LinkId=135960
Feedback
