Acácio Porta Nova wrote:
Hi, is there a way to connect an external database through window authentication?
Hi,
did you ever get an answer if it's possible to connect to an external database through the windows authentication?
The first step in connecting to an external database is to configure the connection in Service Center, as explained in https://success.outsystems.com/Documentation/Development_FAQs/How_to_integrate_with_an_external_SQL_Server_or_ORACLE_database.
This procedure does not support Windows Authentication, as described previously on this thread.
In theory, you can write a C# or Java extension that uses Windows Authentication to connect to a database, but you would lose all the OutSystems visual modeling capabilities that are available for the "external database connection" feature described in the previous link.
So, despiste this theoretical possibility, the short answer to your question is "no".
Frank Sprengers wrote:
I attempt creating a connection string and is able to connect to an external database through windows authentication eventually.https://www.outsystems.com/forums/discussion/18446/connection-to-external-sql-server-database/
Hi Xue,
I am facing the exact same problem, our client that we are developing for has a security policy that only allows Windows Authentication to their SQL Server database, would you mind please sharing an example of the connection string? Much appreciated!
Incase you still need an example:
user id=sa;password=<hidden>;data source = mydatasource,1433; initial catalog = mydatabasename; integrated security = yes;
Reference:
https://www.outsystems.com/forums/discussion/18446/connection-to-external-sql-server-database/
when I use your example the username and password values provided in the advanced configuration seem to be ignored. The apppool user of the platform is used. If I give this user the permissions needed on the database the integrad security works but I would like to be able to choose which user is used in making the connection. Do you know of a way to use a different user for the connection?