Sql server connection using Windows authentication is not working

[debashishsaha004]

I am following this https://access.redhat.com/solutions/1134453.

The problem statement is perfectly matching.

I followed each and every steps mentioned there.

there it was flagged as verified.But I am getting the following stack.

com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:22f7c000-f4c7-4917-a08d-1fc408c96fab

  at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667)

  at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<init>(AuthenticationJNI.java:60)

  at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2229)

  at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)

  at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)

  at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)

  at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)

  at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)

  at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)

  at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)

  at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)

  at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:328)

  at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)

  at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)

  at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)

  at org.eclipse.datatools.enablement.msft.internal.sqlserver.connection.JDBCSQLServerConnectionFactory.createConnection(JDBCSQLServerConnectionFactory.java:27)

  at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)

  at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)

  at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)

  at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)

  at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

Caused by: java.lang.UnsatisfiedLinkError: Native Library C:\Windows\System32\sqljdbc_auth.dll already loaded in another classloader

  at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1907)

  at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1857)

  at java.lang.Runtime.loadLibrary0(Runtime.java:870)

  at java.lang.System.loadLibrary(System.java:1122)

  at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<clinit>(AuthenticationJNI.java:35)

  ... 19 more

Thank you in advance.

[rareddy]

Seems like there is already another JDBC profile in JBDS which loaded this DLL. In Java the DLL can loaded once. My suggestion is check if there is another profile that is loading this DLL, then delete it, restart the JBDS and try again.

[debashishsaha004]

yes .. I figured it out sometime ago.What I did was -I put that dll in system32 whereas it needs to be placed in jre/bin folder.

I tried with system32 but it did not worked.

anyway now I am getting ====

select * from "sqlserver"."dept"

org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for sqlserver were not available.  The command could not be planned properly.

[debashishsaha004]

I cant preview the data.

[rareddy]

The pre-requisite to this to work is, your Windows machine is already participating in SSO with SQLServer. The above indicating that it is not currently doing so.

[debashishsaha004]

But if I can successfully import the schema what can be the difficulties while preview data ?

[debashishsaha004]

[rareddy]

Ok, I see. You did the SQL Server configuration on the JBDS, but when you execute the query it goes to the JDV server. You would need to create a datasource that uses the DLL in server side too. By default when JBDS create the default datasource it does not take DLL stuff into account. so, on server side

- Create module for your SQL Server. See <JDV/docs/teiid/datasources/sqlserver" for instructions. You will need to extend to include the DLL in this VM too. (including in the java's lib as you did for JBDS)

- Create Data source for it

- then you would need to you this datasource in the JBDS. I believe there is way to assign a datasource to a model in JBDS by right clicking on the model.

[debashishsaha004]

I tried with modeling>right click >create data source > it is asking for a password

[debashishsaha004]

it worked.

what I did is ---

1.in the driver properties username and password any dummy data I provided.

2.in the connection profile same dumy values I gave.

3.checked the integrated Security box

now I think teiid designer automatically created the datasource .

Now I can preview.

What I think is may be we can not leave the fields of username and pw in any of the places where it is asking.

thats why teiid designer is not creating the data source.

and one more thing Yes you are right.

I deleted the sqljdbcauth.dll file from where I put it.

restarted the server it worked.so basically windows itself taking care of the authentication as you said earlier.

Thank you for your time.