12
Views
2
Comments
Connect to External SQL Database using AD User
Question

Hello,

My client has a plan to switch all user into AD user, this include the SQL user as well. Currently, our application has 1 connection to their SQL database to queries from their tables. When i tried to create new connection using the AD User and test connection it gives me error

Connection String test failed: Login failed for user 'User name here'.

Is there additional parameter that I'm missing?


mvp_badge
MVP
Rank: #18

Hi Kevin,

With the brief description you wrote of your problem, I would not know how to help you.

Are you talking about AD or AzureAD? AzureAD is something else then AD.

For example AD you need to have an on-premise OutSystems installation, is that the case?

Share the details of the configuration and which code you implemented to authenticate the user.

Share the service center error log in more detail, the call stack is always useful to find the action that raised the exception. From there you can figure out what is wrong.

Regards,

Daniel