Your job does not run successfully after you reinstall the BizTalk Adapter for SQL Server (836457)



The information in this article applies to:

  • Microsoft BizTalk Adapter for SQL Server 1.0

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:

Modification Type:MajorLast Reviewed:3/26/2004
Keywords:kberrmsg kbprb KB836457 kbAudEndUser kbAudDeveloper