Home > Biztalk, Biztalk 2010, Biztalk Deployment Framework, DB2 > DB2 The user does not have the authority to access the host resource. Check your authentication credentials or contact your system administrator

DB2 The user does not have the authority to access the host resource. Check your authentication credentials or contact your system administrator


Deploying the DB2 ports using the deployment framework generated authorization error (shows as warning in the event log) when starting the Biztalk application

The adapter “DB2” raised an error message. Details “The user does not have the authority to access the host resource. Check your authentication credentials or contact your system administrator.”.

To fix that above issue, the DB2 password needs to be typed in the connection string. It seems the deployment framework or exporting the binding doesn’t capture the password.

Advertisements
  1. July 12, 2011 at 10:44 pm

    For security, BizTalk never exports the password into the bindings file. However, you can generally add it back, and even substitute it in automatically from the Deployment Framework for BizTalk’s settings spreadsheet. Every adapter is different, but often there is a Password element in the TransportTypeData. Many times it is exported as an empty element with a vt attribute value that indicates blank. You can change it to vt=”8″ and put the password value into the element, or use a substitution token like ${Password}.

    • Lajak Technologies Inc
      July 13, 2011 at 12:08 am

      Thanks Thomas for the info. I will soon blog about creating configuring WCF-SQL and DB2 adapters. I found few documents I wrote for my previous gig. I have to clean them up first.

      Cheers
      A.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: