Sign in
 
HomeLibraryLearnDownloadsSupportForums
Resources for IT Professionals > Forums Home > BizTalk Server Forums > BizTalk Server RFID > Problem in BizTalk Event Handler
Ask a questionAsk a question
Search Forums:
 

AnswerProblem in BizTalk Event Handler

  • Wednesday, October 14, 2009 5:43 PMNMohanraja Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    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

  • Monday, October 19, 2009 4:33 PMKranthi Kumar M [MSFT] Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    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.

     

All Replies

  • Monday, October 19, 2009 4:33 PMKranthi Kumar M [MSFT] Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote
    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.