Hi
I want to use NTLM based authentication using jdbc connector in teiid. I'm using JBDS
7 with Teiid Designer 8.4. i have downloaded Microsoft JDBC Driver 4.0 for SQL
Server"
fromhttp://www.microsoft.com/en-us/download/details.aspx?id=11774
(
http://www.microsoft.com/en-us/download/details.aspx?id=11774) and In JBDS teiid
designer i have enabled *i**ntegrated Authentication* then I edited Microsoft SQL Server
driver definition, on the Jar list tab i have added the sqljdbc_auth.dll from the
\sqljdbc_4.0\enu\auth\x64 path ,but my am getting this error
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:789)
at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
at
org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:297)
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:81)
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:53)
On the jar list i have added sqljdbc4.jar as well as sqljdbc_auth.dll and tried that
time my jbossstudio is getting crash .
Can anyone help me here? How do i do *i**ntegrated Authentication in teiid.*
* (/update-advanced-comment.jspa?id=881988)
Posted by forums
Original post:
https://community.jboss.org/message/882192#882192