Can Catalog use Windows authentication to connect to a SQL Server database?
Our dba team does not want to give us an SA account for security reasons. Can I enter Windows (or Active Directory) credentials to connect to a SQL Server database?
jeffevoy
Posted 5 years ago · Edited 1 year ago·Last reply 5 years ago
11 comments
jeffevoy
OP5 years ago · EditedThere’s the rub - our Security team will not let us use sql server ids. We have to use Windows (Active Directory) authentication.
Former User
·5 years ago · EditedWe are using “use your own driver” with driver: sqljdbc42.jar. I believe we had to use a sql server database id, instead of a windows id to connect.
arvindsingh
·5 years ago · EditedIf you are using active directory, then there is usually an active directory domain. Your company’s team, which manages your login, should be able to provide that value.
From documentation, Domain is ‘The name of the domain for a Windows (NTLM) security login’.
jeffevoy
OP5 years ago · Edited@pranay.mahendra - do I have to purchase Collibra’s JDBC Driver for SQL Server and do what @arvind.singh is suggesting? Am I not able to use the generic SQL driver?
jeffevoy
OP5 years ago · Edited@pranay.mahendra - do I have to purchase Collibra’s JDBC Driver for SQL Server and do what @arvind.singh is suggesting? Am I not able to use the generic SQL driver?
pmahend3
·5 years ago · EditedYou should be able to use the driver from Mircosoft. However, to state the obvious, the driver name is going to be different and you may want to look up the relevant properties as well - https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15
arvindsingh
·5 years ago · Edited@jeffrey.evoy
I’m using SQL driver from marketplace and here is what driver properties looks like.
arvindsingh
·5 years ago · Edited@jeffrey.evoy
I had similar issue with SQL Server configuration. I’m using active directory.
You have to add ‘Other’ property to your driver and use this value for ‘Other’ in connection properties
IntegratedSecurity=true;NTLMVersion=2;Domain=“your company domain”
Thanks!
jeffevoy
OP5 years ago · Edited@arvind.singh Please excuse my ignorance, but what exactly needs to go in " your company domain”?
Thanks…
pmahend3
·5 years ago · EditedHi Jeff,
Please follow the documentation here - https://community.collibra.com/docs/cloud-user/2020.11/#Catalog/RegisterDataSource/JDBC/ta_manage-jdbc-driver-own-driver.htm.
If you select MSSQL Server as your data source, you’ll find the option to use NTLM authentication.
Cheers
jeffevoy
OP5 years ago · EditedI select SQL Server and use the “mssql_jdbc-7.4.1-jre8_NTLM_auth” driver. I fill in all the info correctly but it still can’t make the connection. Do I have to customize the driver like Arvind is suggesting?