# Unable to connect mssql database **URL:** \ **Category:** Web Testing\ **Tags:** katalon-studio\ **Created:** [April 28, 2020, 9:34pm UTC](https://forum.katalon.com/t/unable-to-connect-mssql-database/42844 "2020-04-28T21:34:44Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![wfskatalon01](https://avatars.discourse-cdn.com/v4/letter/w/f4b2a3/32.png) [@wfskatalon01](https://forum.katalon.com/u/wfskatalon01)\ **Post date:** [April 28, 2020, 9:34pm UTC](https://forum.katalon.com/t/unable-to-connect-mssql-database/42844/1 "2020-04-28T21:34:44Z")
I was trying to connect mssql database but unable to connect due to below listed errors. public static void connectiontest () { ``` Connection conn = null; try { //Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver") String dbURL = "jdbc:sqlserver://WWW-WAB-D12\\TCSSFC11T:1433;databaseName=ABC;integratedSecurity=true;" //String port = ""; String user = "ABC"; String pass = "Abc@123"; conn = DriverManager.getConnection(dbURL, user, pass); if (conn != null) { DatabaseMetaData dm = (DatabaseMetaData) conn.getMetaData(); System.out.println("Driver name: " + dm.getDriverName()); System.out.println("Driver version: " + dm.getDriverVersion()); System.out.println("Product name: " + dm.getDatabaseProductName()); System.out.println("Product version: " + dm.getDatabaseProductVersion()); } } catch (SQLException ex) { ex.printStackTrace(); } finally { try { if (conn != null && !conn.isClosed()) { conn.close(); } } catch (SQLException ex) { ex.printStackTrace(); } } } ``` Apr 28, 2020 4:29:27 PM com.microsoft.sqlserver.jdbc.AuthenticationJNI WARNING: Failed to load the sqljdbc\_auth.dll cause : no sqljdbc\_auth in java.library.path com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:d6389e04-9545-479f-acc9-36b7c3a30d91 at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1745) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:58) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2355) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:43) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2346) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1793) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1404) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1068) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:904) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:451) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1014) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at java\_sql\_DriverManager$getConnection.call(Unknown Source) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:141) at pageobject.JdbcSQLServerConnection.connectiontest(JdbcSQLServerConnection.groovy:24) at pageobject.JdbcSQLServerConnection$connectiontest.call(Unknown Source) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117) at Script1588098119758.run(Script1588098119758.groovy:35) at com.kms.katalon.core.main.ScriptEngine.run(ScriptEngine.java:194) at com.kms.katalon.core.main.ScriptEngine.runScriptAsRawText(ScriptEngine.java:119) at com.kms.katalon.core.main.TestCaseExecutor.runScript(TestCaseExecutor.java:337) at com.kms.katalon.core.main.TestCaseExecutor.doExecute(TestCaseExecutor.java:328) at com.kms.katalon.core.main.TestCaseExecutor.processExecutionPhase(TestCaseExecutor.java:307) at com.kms.katalon.core.main.TestCaseExecutor.accessMainPhase(TestCaseExecutor.java:299) at com.kms.katalon.core.main.TestCaseExecutor.execute(TestCaseExecutor.java:233) at com.kms.katalon.core.main.TestCaseMain.runTestCase(TestCaseMain.java:114) at com.kms.katalon.core.main.TestCaseMain.runTestCase(TestCaseMain.java:105) at com.kms.katalon.core.main.TestCaseMain$runTestCase$0.call(Unknown Source) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:149) at TempTestCase1588109362227.run(TempTestCase1588109362227.groovy:23) at groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:263) at groovy.lang.GroovyShell.run(GroovyShell.java:518) at groovy.lang.GroovyShell.run(GroovyShell.java:507) at groovy.ui.GroovyMain.processOnce(GroovyMain.java:653) at groovy.ui.GroovyMain.run(GroovyMain.java:384) at groovy.ui.GroovyMain.process(GroovyMain.java:370) at groovy.ui.GroovyMain.processArgs(GroovyMain.java:129) at groovy.ui.GroovyMain.main(GroovyMain.java:109) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.codehaus.groovy.tools.GroovyStarter.rootLoader(GroovyStarter.java:109) at org.codehaus.groovy.tools.GroovyStarter.main(GroovyStarter.java:131) Caused by: java.lang.UnsatisfiedLinkError: no sqljdbc\_auth in java.library.path at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1867) at java.lang.Runtime.loadLibrary0(Runtime.java:870) at java.lang.System.loadLibrary(System.java:1122) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:32) … 50 more ---
**Author:** ![Timo\_Kuisma1](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/timo_kuisma1/32/16103_2.png) [@Timo\_Kuisma1](https://forum.katalon.com/u/Timo_Kuisma1)\ **Post date:** [April 29, 2020, 4:42am UTC](https://forum.katalon.com/t/unable-to-connect-mssql-database/42844/2 "2020-04-29T04:42:21Z")
hi, you are missing driver > ---
**Author:** ![lalitha.jyothi](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/lalitha.jyothi/32/16104_2.png) [@lalitha.jyothi](https://forum.katalon.com/u/lalitha.jyothi)\ **Post date:** [November 19, 2021, 11:19am UTC](https://forum.katalon.com/t/unable-to-connect-mssql-database/42844/3 "2021-11-19T11:19:38Z")
Hi, I have this driver, still getting the same error.What else could be missing? ---
**Author:** ![tomislav.duic](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/tomislav.duic/32/16104_2.png) [@tomislav.duic](https://forum.katalon.com/u/tomislav.duic)\ **Post date:** [December 13, 2021, 10:59pm UTC](https://forum.katalon.com/t/unable-to-connect-mssql-database/42844/4 "2021-12-13T22:59:50Z")
I was struggling past few hours with the exact same problem. And the solution came while **carefully** reading the first console error: no sqljdbc\_auth in java.library.path. The file I downloaded from Microsoft is called mssql-jdbc\_auth-9.2.1.x64.dll. If you copy it to \jre\bin, it doesn’t work. But if you rename it to sqljdbc\_auth.dll, then it works. 🙂 Silly, but it is what it is. ---
**Author:** ![bpatil](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/bpatil/32/16104_2.png) [@bpatil](https://forum.katalon.com/u/bpatil)\ **Post date:** [May 22, 2022, 5:51am UTC](https://forum.katalon.com/t/unable-to-connect-mssql-database/42844/5 "2022-05-22T05:51:22Z")
> [@tomislav.duic](#): > > sqljdbc\_auth.dll thank you ! its working