Database Connection with Windows Authentification

[Mariteemo]

Hi there,

I am looking for a solution to the following issue (I have just found some hold posts down to 2014, but nothing concerning the following node):

I want to connect my MS-SQL-Database with a Microsoft-SQL-Connector-Node and Windows authentification.
I can’t really find a way to create or add those credentials to the WF.

Could anyone help me with it?

Thanks and cheers.
Martin

[s.roughley]

I think you can achieve this using the Credentials Input node. I think that the Use KNIME Server Login option will give access to the windows login when running locally - not 100% certain though - you may need to reenter the windows password in this case.

Steve

[Mariteemo]

Hi Steve,

firstly, thanks for your fast reply.
I have just tried it, but I don’t have a KNIME-Server yet.
I understand your solution and it will work with the server for sure, but for now, I can’t use it this way.

I guess it could be useful to explain it a little more detailled:
I use a MS-SQL-Database which is defined as confidential. The only way, someone is allowed to access to, is via PKI-certificates, so it’s not possible to get access only by WinUser and password. Nevertheless, we need access with KNIME as well. TBH, I am a bit impatient and don’t want to wait for the KNIME-server.

Is there maybe a solution to get the WinAuthentification in another way (perhaps a java snippet )?

Cheers
Martin

[ipazin]

Hi!

Have you seen this topic?

connect to ms sql server by windows authentication

Install JDBC Driver inside of KNIME (if not already done) In KNIME go to File > Install Extensions. Search for SQL Server. Select the JDBC Driver for SQL Server, then install it. Download Microsoft SQL SERVER JDBC Driver Here is current download link (if it doesn’t work just Google “Download Microsoft SQL SERVER JDBC Driver”) https://www.microsoft.com/en-us/download/details.aspx?id=57175 Choose the .exe file which will self extract the drivers to the location you choose. In the extracted f…

Br,
Ivan

[Mariteemo]

Hi Ivan,

I have seen the topic, but I didn’t believe that this is the most efficient way, because there is a Microsoft-SQL-Server-Node. It works thanks to your post!

The only thing, I had to figure out on my own, is the port-definition (actually it is quite simple):

Just enter the Database URL: jdbc:sqlserver://CONNECTIONSTRING;Port=PORTNR;Database=DATABASENAME;integratedSecurity=true

Even I don’t have any problem anymore, it is interesting to know, why it doesn’t work with the MS-SQL-Server-Node.

Thanks to you both!
Cheers Martin

[ipazin]

Hi Martin,
I’m glad it works
Soon new Database Integration nodes are coming into production (currently they are available as Labs Extension) so maybe this is already addressed.
Ivan