No, BizTalk will use the BizTalk service account context. You can specify a SQL login in the connection string if you want. BizTalk does have a provision for passing the user account context along with the message: Single Sign-On (SSO). Many BizTalk adapters have SSO support, although maps and functoids do not. Another option might be to use the SQL adapter instead of a map to access SQL Server. The SQL adapter and SSO might be a solution for you. (I don’t know whether the SQL adapter supports SSO, you would need to do some research)
Search this Site:
Recent Posts
- Logic App Consumption deployment: The secret of KeyVault parameter cannot be retrieved. Http status code: ‘Forbidden’. Error message: ‘Access denied to first party service
- BizTalk Server Visual Studio project: attempted re-targeting of the project has been canceled.
- BizTalk Oracle Adapter error: The assembly required for type mapping not found.
- PowerShell script to identify all SQL V1 actions and triggers inside Logic Apps Consumption
- Friday (funny) Fact: There is no size limit for the Logic App parameter name