6 Replies Latest reply on Jul 22, 2014 8:09 AM by ambili venugopal

    NTLM in Teiid

    Madhurika Sharma Newbie

      I want to use NTLM based authentication using jdbc connector in Teiid. I have tried to create a connecton to Database using:

      1. Create Teiid Model Project-> Source ->Import->JDBC Connection

      2. I see a feature called integrated security checkbox in Specify a Driver and Connection profile.

      I need a help to understand if integrated security is same as NTLM and if possible, Kindly give me the steps to connect to database using NTLM

        • 1. Re: NTLM in Teiid
          Steven Hawkins Master

          Someone from the Designer Team or with more knowledge about Data Tools may need to weigh in here, but this feature may not work - https://bugs.eclipse.org/bugs/show_bug.cgi?id=233565

           

          What database are you accessing?

           

          You'll also want to separate out somewhat the design time and runtime concerns.  It may be possible to do use ntlm at runtime even if there is an issue at runtime.  Ramesh has just done quite a bit validating Kerberos support, which could be useful: How to implement Kerberos authentication with Teiid over JDBC

          • 2. Re: NTLM in Teiid
            Madhurika Sharma Newbie

            Hello Steven , I am using SQL Server Database .

            I can see an option of Use Integrated Authentication in Teiid designer while creating a connection.When i am enabling it, i am getting an error : this driver is not configured for integrated authentication. I am using sqljdbc4.jar .
            After researching a bit about NTLM i have found that sqljdbc_auth.dll is required for this kind of connection. When i using this jar , jboss developer studio is getting crashed.

            Can you help me to understand the use of 'Use Integrated Authentication in Teiid Designer' ? and How to use it?

            • 3. Re: NTLM in Teiid
              Steven Hawkins Master

              > Can you help me to understand the use of 'Use Integrated Authentication in Teiid Designer' ? and How to use it?

               

              It appears that it should set the integrationAuthentication flag use the logged in users credentials for authentication.  But it may not work according to that bug report.  So unfortunately it will take someone with more Data Tools expertise, as that is where the feature is coming from.

               

              I'm also not aware of anyone setting up NTLM authentication on the server side, but it should be possible there as well.   Have you tried creating an AS/EAP data source using NTLM authentication?

              • 4. Re: NTLM in Teiid
                Barry LaFond Master

                All Non Teiid Designer connection profiles are contributed to Eclipse Data Tools project, including the SQL Server profile. I tested the check box and got the same result. If the profile can't connect in the Data Source Explorer view, then Designer can't utilize the connection.

                 

                Steve's link above will get you to:  http://msdn.microsoft.com/en-us/library/ms378428.aspx which describes how and where to use the sqljdbc_auth.dll file.

                 

                If you can get Data Tools to connect via this option and Designer can't import from that source, then log a JIRA and include the details.

                 

                Barry

                Teiid Designer

                • 5. Re: NTLM in Teiid
                  Debbie Steigner Newbie

                  I was able to get past the "this driver is not configured for integrated authentication" (I do not have a SQL Server with NT Authentication, so I get login failed).

                   

                  1. This will only work if JBDS is installed on Windows.  I'm using JBDS 7.1.1 with Teiid Designer 8.3.3
                  2. Download the "Microsoft JDBC Driver 4.0 for SQL Server" from http://www.microsoft.com/en-us/download/details.aspx?id=11774
                  3. Extract the file.
                  4. In JBDS, edit your Microsoft SQL Server driver definition, on the Jar list tab add the sqljdbc_auth.dll from the \sqljdbc_4.0\enu\auth\x64 or \sqljdbc_4.0\enu\auth\x86 directory, depending on whether you are using 32 or 64 bit.

                  • 6. Re: NTLM in Teiid
                    ambili venugopal Newbie

                    Helloo Debbie

                    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" from http://www.microsoft.com/en-us/download/details.aspx?id=11774 (as you suggested)  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 jboss developer studio is getting crashed and am not able to do the Integrated Authentication in teiid.

                    Can you help me here?