|
Home > Archive > BizTalk Server Administration > March 2004 > Adapter for SQL & Access denied
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Adapter for SQL & Access denied
|
|
| Bartosz Matuszczak 2004-03-23, 2:43 pm |
| Hi
I'm using Biztalk 2002 Dev on Server 2003 with SQL Adapter.
After correctly configured BTSAdapterDemo i try to start it
but i get the following error:
---------------------------------------------
A worker thread reported a failure: Access is denied.
The error code is shown in the data area below.
The operation was: CoCreateInstance(CLSID_SQLWorker)
The worker thread was working on:
Job Name: StagingInventory
SQL Script: Exec [sp_StagingInventoryCheck2]
----------------------------------------------------
The task can access the DB through the .udl file with an
SQL connection, the stored procedures are displayed, the
schema is generated, but the task doesn't start.
I don't understand where is access denied. Biztalk works well, Sql server
too.
Logon properties for RFSQL Service are default (Administrator)
Thanks
Bart.
| |
| Basil Cheng 2004-03-26, 12:31 pm |
| Please check the following
http://support.microsoft.com/?id=836457
Please make sure that the Biztalk adapter for SQL server com+ package, does
not have enforce security check checked.
Also make sure that the identity used to run that package has appropriate
rights. set it to admin, and make sure that it has permission on the SQL
box as well.
If the above is not the applicable, you might want to run the SQL adapter
trace to find out what the problem is.
Hope this helps,
Regards.
Basil Cheng
Microsoft Biztalk Developer Support
This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
|
|
|