3 Replies Latest reply on Jul 25, 2014 11:21 AM by maxandersen

    NTLM in Teiid

    ambili
    ambili Jul 24, 2014 8:13 AM

      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  and In JBDS teiid designer i have enabled integrated 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 integrated Authentication in teiid.