6 Replies Latest reply on Apr 20, 2015 3:43 PM by Kent Graziano

    SQLDev 4.1 EA2 - issue with SSO connection to SQL Server (again)

    Kent Graziano

      I am trying to connect to SQL Server with the new version. I have the jtds 1.3 installed and get the SQL Server setup tab but once again get the infamous SSO error trying to connect:

       

      Status : Failure -I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.


      I have tried copying ntlmauth.dll to several locations:

      C:\Oracle\sqldeveloper4.1\sqldeveloper\sqldeveloper\bin

      C:\Oracle\sqldeveloper4.1\sqldeveloper\jdk\jre\bin

      C:\Oracle\sqldeveloper4.1\sqldeveloper\jdk\jre\

      C:\Oracle\sqldeveloper4.1\sqldeveloper\jdk\

       

      Restarted SQLDev, but still getting the SSO error.

        • 1. Re: SQLDev 4.1 EA2 - issue with SSO connection to SQL Server (again)
          Turloch O'Tierney-Oracle

          Hi Kent,

           

          What is your java.library.path Assumption dll is on the path and is readable.

          What is your jtds 1.3 version Assumption: 1.3.1.

          What is your SQLServer version? (unknown)

           

          I can try a connection from my desk: a windows 7 machine.

           

          Turloch

          -SQLDeveloper Team

           

          From a previous thread:

          Jens,
          Where do i find this java.library.path system property?
          thanks in advance
          -gopal

          Answer:

             

          In SQL Developer go to help..about and click on the properties tab.

          The key and value will be in there.

          • 2. Re: SQLDev 4.1 EA2 - issue with SSO connection to SQL Server (again)
            Turloch O'Tierney-Oracle

            Hi Kent,

             

            I connected OK.

            SQLServer was already configured from last test for a previous sqldeveloper version.

            I refreshed jdk/jtds/sqldev/Created a new connection.

             

            Are you using:

            x64 java

            and

            x64 dll?

             

            -Turloch

            SQLDeveloper Team

             

            Connected to:

            Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)

             

            On:

            Windows Server 2008 Enterprise

             

            Jtds:

            1.3.1 x64 dll

             

            Java

            1.8.0_45 x64

             

            SQLDeveloper:

            sqldeveloper-4.1.0.18.37

            1 person found this helpful
            • 3. Re: SQLDev 4.1 EA2 - issue with SSO connection to SQL Server (again)
              Kent Graziano

              How do I tell if I have the x64 dll for JTDS? I downloaded the only JTDS 1.3.1 I could find.

               

              For SQL Dev, I installed the version with the embedded JDK. Properties say:

               

              Java version is 1.8.0_40-b25.

              Java library path includes C:\Oracle\sqldeveloper4.1\sqldeveloper\sqldeveloper\bin

              SQL Dev version 4.1.0.18.37

              • 4. Re: SQLDev 4.1 EA2 - issue with SSO connection to SQL Server (again)
                Turloch O'Tierney-Oracle

                Hi Kent,

                 

                >How do I tell if I have the x64 dll for JTDS? I downloaded the only JTDS 1.3.1 I could find.

                extract the distribution file from http://sourceforge.net/projects/jtds/files/latest/download

                path x64\SSO (shown in detail below).

                 

                >For SQL Dev, I installed the version with the embedded JDK. Properties say:

                I used the no-jre version and downloaded the latest 64bit java

                (64bit jre installs by default into c:\Program Files\... rather than c:\Program Files (x86)\...)

                (I do not see a 4.1EA2 "with jre" version in SQL Developer 4.1 Early Adopter )

                 

                -Turloch

                SQLDeveloper Team

                 

                Directory of ...\jtds-1.3.1-dist

                 

                04/15/2015  01:18 PM    <DIR>          .

                04/15/2015  01:18 PM    <DIR>          ..

                04/15/2015  01:18 PM           182,051 CHANGELOG

                04/15/2015  01:18 PM    <DIR>          conf

                04/15/2015  01:18 PM    <DIR>          html

                04/15/2015  01:18 PM    <DIR>          IA64

                04/15/2015  01:18 PM           317,816 jtds-1.3.1.jar

                04/15/2015  01:18 PM            26,428 LICENSE

                04/15/2015  01:18 PM             3,947 README

                04/15/2015  01:18 PM             6,071 README.SSL

                04/15/2015  01:18 PM             7,141 README.SSO

                04/15/2015  01:18 PM             2,916 README.XA

                04/15/2015  01:18 PM    <DIR>          x64

                04/15/2015  01:18 PM    <DIR>          x86

                 

                C:\...jtds-1.3.1-dist>dir x64\SSO

                Volume in drive C has no label.

                Volume Serial Number is F895-4999

                 

                Directory of C:\...l\jtds-1.3.1-

                ist\x64\SSO

                 

                04/15/2015  01:18 PM    <DIR>          .

                04/15/2015  01:18 PM    <DIR>          ..

                04/15/2015  01:18 PM            39,424 ntlmauth.dll

                               1 File(s)         39,424 bytes

                               2 Dir(s)  105,459,675,136 bytes free

                1 person found this helpful
                • 5. Re: SQLDev 4.1 EA2 - issue with SSO connection to SQL Server (again)
                  Kent Graziano

                  I found the x64 DDL and moved that into the Java library path \sqldeveloper\sqldeveloper\bin

                   

                  Still not working. Same SSO error.

                   

                  (FYI - I got the jre when I downloaded Data Modeler. My mistake.)

                   

                  So everything is in place where it should go. Any other ideas how to troubleshoot this? It is critical to a project I am on right now. I need this to work for both SQL Developer and Data Modeler.

                   

                  Thanks.

                  • 6. Re: SQLDev 4.1 EA2 - issue with SSO connection to SQL Server (again)
                    Kent Graziano

                    Found this issue (thanks to Jeff Smith!). I had a 32 bit DLL in the path that conflicted with the 64 bit one. Once I deleted all the extra 32 bit versions, the SSO authentication works.