Hi all,
we are trying to create a Generic DB Connector with remote connection.
When the Wizard asks to insert the credentials, and we try to retrieve the list of databases, we get the error "The databases on the SQL server could not be determined automatically". Insted, if we write the database name and try to login we get "Login failed for user 'username'".
We know we have got a Windows user for authenticating in the SQL database. So we then tried to look into the Extended properties, and we set the Authentication field as "ActiveDirectoryPassword". The error we get when we try to authenticate is "A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)".
So, we tried setting TrustServerCertificate = True and we get the error "Login failed for user ''.", and it seems like it's ignoring the username we inserted.
We repeated the same tests both with username and domain\username, but we got the same errors.
What is it that we are missing? It's some SQL or permissions related issue or a One Identity configuration?
Thank you all for the support,
Lucrezia
