Resources for IT Professionals >
Forums Home
>
BizTalk Server Forums
>
BizTalk Server RFID
>
Problem in BizTalk Event Handler
Problem in BizTalk Event Handler
- Hi,
I'm trying to create custom event handler for BizTalK RFID process. I refered the below link for create event handler.
http://msdn.microsoft.com/en-us/library/dd298695%28BTS.10%29.aspx.
It was working fine after adding the dll into process. After that i tried to create connection with local sql server 2008 database. When i start the process it gives the following errror.
"Component MyEventHandler threw exception during initialization. Details: Cannot open database "uniform_tracking" requested by the login. The login failed.
Login failed for user 'WS03_OFFICE07\RFIDWorkerProcessAcc'.. Resolve the issue that is causing the exception, and then retry the operation."
Please any one help me in this issue.
Thank you.
Answers
- Hi,
It looks like your custom event handler is trying to access the database 'uniform_tracking'. In BizTalk RFID, your code in the custom event handler runs under the RFID Worker Process Account (in your case, this account is 'WS03_OFFICE07\RFIDWorkerProcessAcc', as mentioned in the error message).
So, grant the required permissions to this account, and everything should work fine ('required permissions' will consist of granting login permissions to the appropriate SQL Server and granting appropriate access permissions on the appropriate databases over there).
HTH,
Kranthi.
- Marked As Answer byAndrew_ZhuMSFT, ModeratorThursday, October 22, 2009 2:19 AM
All Replies
- Hi,
It looks like your custom event handler is trying to access the database 'uniform_tracking'. In BizTalk RFID, your code in the custom event handler runs under the RFID Worker Process Account (in your case, this account is 'WS03_OFFICE07\RFIDWorkerProcessAcc', as mentioned in the error message).
So, grant the required permissions to this account, and everything should work fine ('required permissions' will consist of granting login permissions to the appropriate SQL Server and granting appropriate access permissions on the appropriate databases over there).
HTH,
Kranthi.
- Marked As Answer byAndrew_ZhuMSFT, ModeratorThursday, October 22, 2009 2:19 AM
