JDBC Driver faulted (Microsoft SQLServer) faulted

[CCoker1]

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?

[Paul.Scott]

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. 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).

[CCoker1]

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?

[Paul.Scott]

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

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.

[MSAAVEDRA7121]

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…

[MSAAVEDRA7121]

Just realized first image did not load here it is…