# JDBC Driver faulted (Microsoft SQLServer) faulted **URL:** \ **Category:** Ignition\ **Created:** [November 13, 2019, 4:33pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-faulted-microsoft-sqlserver-faulted/29917 "2019-11-13T16:33:47Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![CCoker1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ccoker1/32/22605_2.png) [@CCoker1](https://forum.inductiveautomation.com/u/CCoker1)\ **Post date:** [November 13, 2019, 4:33pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-faulted-microsoft-sqlserver-faulted/29917/1 "2019-11-13T16:33:47Z")
My Database Connection, JDBC Driver (Microsoft SQLServer) is faulted. My Easy Chart I created is red. I’m trying to set up a Tag Historian for a couple of tags. I have the following errors: Exception: Error running query: TagHistory(paths=[prov:default:/tag:D22\_11898/BC\_Passed, prov:default:/tag:D22\_11898/BC\_Failed], start=Wed Nov 13 10:40:00 EST 2019, end=Wed Nov 13 11:24:59 EST 2019, flags=0)@0ms On: D17\_Statistics.Root Container.Easy Chart caused by GatewayException: The database connection ‘JVLTenneco\_MES’ is FAULTED. See Gateway Status for details. caused by FaultedDatabaseConnectionException: The database connection ‘JVLTenneco\_MES’ is FAULTED. See Gateway Status for details. Ignition v8.0.5 (b2019101516) Java: Azul Systems, Inc. 11.0.4 When I go to the Gateway and go to “Databases” I get the following error: java.sql.SQLException: Cannot create PoolableConnectionFactory (The server FTVIEWX64TAGDB is not configured to listen with TCP/IP.) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2385) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2110) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1563) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:257) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:211) at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.lambda$newRetryRunnable$0(DatasourceManagerImpl.java:1017) at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:565) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The server FTVIEWX64TAGDB is not configured to listen with TCP/IP. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:228) at com.microsoft.sqlserver.jdbc.SQLServerConnection.getInstancePort(SQLServerConnection.java:5923) at com.microsoft.sqlserver.jdbc.SQLServerConnection.primaryPermissionCheck(SQLServerConnection.java:2347) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2083) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1950) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1162) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:735) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:53) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:291) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2395) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2381) … 12 more 8.0.5 (b2019101516) Azul Systems, Inc. 11.0.4 Could anyone help with what could be causing this issue? ---
**Author:** ![Paul.Scott](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul.scott/32/4578_2.png) [@Paul.Scott](https://forum.inductiveautomation.com/u/Paul.Scott)\ **Post date:** [November 13, 2019, 4:45pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-faulted-microsoft-sqlserver-faulted/29917/2 "2019-11-13T16:45:34Z")
> java.sql.SQLException: Cannot create PoolableConnectionFactory (The server FTVIEWX64TAGDB is **not configured to listen with TCP/IP** Take a look at the "Check 1: Make Sure the Database has TCP/IP Enabled" header here: [SQL Server Connection Guide](https://docs.inductiveautomation.com/display/DOC80/Connecting+to+Microsoft+SQL+Server+Express#ConnectingtoMicrosoftSQLServerExpress-MicrosoftSQLServerConnectionGuide). It sounds like the error wants you to enabled TCP/IP. From personal experience, you may want to run through the rest of the troubleshooting tips on that page too (making sure the browser is running, SQL authentication is enabled, etc). ---
**Author:** ![CCoker1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ccoker1/32/22605_2.png) [@CCoker1](https://forum.inductiveautomation.com/u/CCoker1)\ **Post date:** [November 13, 2019, 5:22pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-faulted-microsoft-sqlserver-faulted/29917/3 "2019-11-13T17:22:25Z")
![Scenario2](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/5c6f68984b8569cb4b575b8b061f4556dae649fc.png) ![sqljdbc](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a329d813839b86ad1d643f4d2334784945cad4d3.png) ![SQLServer_Running](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c257c2889691ca43b67368b77d8a1de6f6837613.png) ![TCPIP_Enabled](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/d80eeb4ecc63d457e08825406e204dfc0ad75a04.png) Thanks for the reply Paul! I’ve been going through and verifying I have it configured correctly. Ran into a snag, I couldn’t locate the sqljdbc\_auth.dll file. I do have a .dll file, but not the sqljdbc\_auth.dll file. Should I use the .dll file that I have attached? ---
**Author:** ![Paul.Scott](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul.scott/32/4578_2.png) [@Paul.Scott](https://forum.inductiveautomation.com/u/Paul.Scott)\ **Post date:** [November 13, 2019, 7:31pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-faulted-microsoft-sqlserver-faulted/29917/4 "2019-11-13T19:31:34Z")
Well, it looks like step one of that scenario is missing an important peice: the file is located in Microsoft’s JDBC driver for SQL server, which you’ll need to download. I’ve asked a writer to update that example, but you can find the driver here: [SQL Server JDBC](https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15) If you must use windows authentication, then you’ll need to pick a comparable driver version (Your gateway is using Java 11). Also, you don’t want the installer, rather you want the .tar.gz, so you can extract the .dll. ---
**Author:** ![MSAAVEDRA7121](https://avatars.discourse-cdn.com/v4/letter/m/b4bc9f/32.png) [@MSAAVEDRA7121](https://forum.inductiveautomation.com/u/MSAAVEDRA7121)\ **Post date:** [March 5, 2021, 2:37am UTC](https://forum.inductiveautomation.com/t/jdbc-driver-faulted-microsoft-sqlserver-faulted/29917/5 "2021-03-05T02:37:21Z")
Hello, I am having this error with Microsoft SQLExpress. Could you give me some idea as to what to look at? (upload://71O3EYuHH7bliUSZlICuKV6tvFu.png) these are my settings with in the config manager… ![ProtocolSQLEXPRESS](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/6/1626f7fc51ab9548af4cd0879423cea1574a8ef6.png) ![ServerServices](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/5/1536c85360726b6ed1cd129eb7604ea3401d3519.png) ---
**Author:** ![MSAAVEDRA7121](https://avatars.discourse-cdn.com/v4/letter/m/b4bc9f/32.png) [@MSAAVEDRA7121](https://forum.inductiveautomation.com/u/MSAAVEDRA7121)\ **Post date:** [March 5, 2021, 2:38am UTC](https://forum.inductiveautomation.com/t/jdbc-driver-faulted-microsoft-sqlserver-faulted/29917/6 "2021-03-05T02:38:27Z")
Just realized first image did not load here it is… ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/1/3143855dcaa023f59b67639af8c1e9ba81cea560.png)