0 Replies Latest reply on Aug 24, 2015 1:23 AM by RonanM

    Using Windows Authentication when connecting to a MSSQL Database using the plugin

    RonanM Lurker
    VMware Employees

      Hi All,

      I think this is too specific for a KB, so I hoipe this is useful to someone!

       

      You can use the workflow create a "JDBC url" to create a valid jdbc connection which you can then copy pasta into the "add a database" Dialog. I think it is a bit unclear however on how to get it to use Windows authentication! If you add:


      ;useNTLMv2=true;domain=DOMAIN


      Where DOMAIN is your domain, it should work. Your username is just the user without the domain. The full example string is:


      "jdbc:jtds:sqlserver://sql.mydomain.local:1433/Test_DB;useNTLMv2=true;domain=MYDOMAIN";


      Hope this helps,


      Ronan