Microsoft KB Archive/836457

= Your job does not run successfully after you reinstall the BizTalk Adapter for SQL Server =

Article ID: 836457

Article Last Modified on 1/22/2007

-

APPLIES TO


 * Microsoft BizTalk Adapter for SQL

-





SYMPTOMS
If you reinstall the Microsoft BizTalk Adapter for SQL Server, and then you run a job that was configured previously, the job does not run successfully. When this problem occurs, the following message appears in the event viewer log: Source: RFSQL

Event id: 10

A worker thread reported a failure: Access is denied.



CAUSE
This problem may occur if you remove and then reinstall the BizTalk Adapter for SQL Server.

When you reinstall the BizTalk Adapter for SQL Server, some of the default security settings of COM+ applications that are located on the server are modified. By default, the Enforce access checks for this application security setting is disabled. This error occurs because this setting has been enabled.



RESOLUTION
To resolve this problem, click to clear the Enforce access checks for this application check box. For additional information about how to do this, and about how to configure access checks at the application level or at the component level, click the following article number to view the article in the Microsoft Knowledge Base:

810153 PRB: Access check is enabled by default when a COM+ application is created



MORE INFORMATION
For additional information about the BizTalk Adapter for SQL Server, visit the following Microsoft Web site:

http://www.microsoft.com/biztalk/evaluation/overview/default.mspx

Keywords: kberrmsg kbprb KB836457

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.