How to Specify DB Connection for BRE
The scenario is as follows:
1) in the RuleEnginePolicyExecutor's rules configuration, under Database Facts, I have the following connectionstring:
Data Source = (local);Initial Catalog=<mydbname>
TableName = <mytablename> where I have the facts
Dataset Name = <datasetname> that is same as the DataSetName in BRE.
When I start the process, I get the following error:
Component POCComponentInstance1 threw exception during initialization. Details: Login failed for user ''. The user is not associated with a trusted SQL Server connection.. Resolve the issue that is causing the exception, and then retry the operation.
I'm not using SSPI. How can I resolve this issue?
Thanks,
[754 byte] By [
DRoy99] at [2008-2-3]
Hi,
Currently BizTalk RFID supports only Integrated security for database facts. The user account under which the RFID Process runs (RFID Services account on Windows XP/Vista ; RFID Worker Process account on Windows 2003) needs to have access permissions to any database that the BRE policy refers to.
Please refer to the following section of the BizTalk RFID documentation for details:
Using Business Rules During Event Processing > Using Policies in RFID Processes > Specifying Persistent Facts > Specifying Database Facts.
HTH.
Thanks,
Rohan Makhija.
Thanks a lot. It worked!
I have another question. I'm new to BizTalk. So far we have been using RFID Manager to create process, attach new event handlers etc. Wondering how can we use BizTalk orchestration to do the same?
Any help is highly appreciated.
Thanks,
Roy
