Connection to external data source using windows authentication (NTLM) What I have done temporarily is that I wrapped my code that connects to the SQL DB with SPSecurity.RunWithElevatedPrivileges which made SharePoint able to pass the app bool credentials to SQL DB. And hence the access succeeded.
meta user
network profile
