PB12.5
Appeon 2016
The current application authenticate the user using SSO with Windows Active Directory
Most of the triggers and many PB code and Store Procedures use the user connected to perform some operations and save audit trail.
there are more than 1000 users
all the Users will be connected to the Entreprise Network no external users for the current application are expected.
checking the dynamic Database Connection does not solve the problem cause the users have only the NT authentication not a DB authentication.
Any way allow a Dinamic Database connection with SSO?
or the only solution is to change the to DB authentication to the users and have 2 passwords?
Changing the code to not use a Dinamic Database connection is not a solution cause are many non PB application that use the same triggers and procedures and some external real time auditing that use the user connected information.
using Appeon users does not solve the DB connection issue
Please Help
The issue is that the customer is asking if they can keep the SSO to the database server not the application itself.
i will try the steps you wrote and let you know
i have try your solution.
My problem remains the same the database server (MS SQL SERVER) is set to windows authentication so there is no user/password to set the dataSource and if i check the Dynamic Database Connection it requires a User / password that i don't have
i try to set the Other Options with : integratedSecurity=true or TrustedConnection=1 or Secure=1
and the problem remains i recieve and error on the login to the database during connect;