Clovertech

CL 6.1 JDBC connection to MS SQL with integrated security

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › CL 6.1 JDBC connection to MS SQL with integrated security

  • Creator
    Topic
  • May 11, 2015 at 1:03 pm #54676
    Sergey Sevastyanov
    Participant

      Cloverleaf 6.1 on Windows Server 2008/2012

      I am trying new database protocol and I can’t setup a connection to MS SQL using integrated security. If I use SQL user and password I am able to connect. But we prefer using integrated security.

      When I set connection as

      Quote:

      jdbc:sqlserver://mysqlserver:1433;DatabaseName=mydatabase;integratedSecurity=true


      I got the following error:

      Quote:

      This driver is not configured for integrated authentication.

      Just out of curiosity I tried to explicitly specify network id (in domainuser format) and password (even though I am not going to use it that way) but that didn’t work either. Tried slash instead of backslash, double backslash – neither works.

      Anybody here had success to use integrated security?

      We’ve been successfully using TclODBC for querying MS SQL in CL 5.7 and if new database protocol can’t work with integrated security I guess we can continue using TclODBC.

    • Creator
      Topic
    Viewing 3 reply threads
    • Author
      Replies
      • May 11, 2015 at 8:27 pm #82532
        Levy Lazarre
        Participant

          Sergey,

          It looks like your connection string may need a little bit of tweaking.

          Check out this article (option 1):

          Code:


          https://thusithamabotuwana.wordpress.com/2012/07/19/connecting-to-sql-server-from-java/

          Another alternative is to use the JTDS driver instead of the Microsoft JDBC driver.

          I hope this helps.

        • June 8, 2015 at 4:55 pm #82533
          Mike Strout
          Participant

            Sergey,

            Did you ever get integrated authentication working with the JDBC drivers? I read through the article posted by Levy, but I still wasn’t able to get it going. I also did some research on the M$ site and found an article suggesting the need to setup Kerberos and a Kerberos conf file.

            Were you able to figure this out?

            Mike

          • June 8, 2015 at 5:51 pm #82534
            Sergey Sevastyanov
            Participant

              Mike,

              No, to be honest, I didn’t have time to try as there are some more urgent issues.

              I figured that I will try when (and if) I have more time to play. For now I settled on saving data in Tcl using TclODBC.

              If you figure it out I appreciate if you could share.

              Sergey

            • June 8, 2015 at 6:15 pm #82535
              Mike Strout
              Participant

                Thanks for the quick response. I certainly will keep you posted if/when I get some concrete answers.

                Mike

            • Author
              Replies
            Viewing 3 reply threads
            • The forum ‘Cloverleaf’ is closed to new topics and replies.