After configuring SQL Server as either a primary data source or business data source to use with Appian, users might encounter the following error during JBoss startup:
org.hibernate.exception.GenericJDBCException: Cannot open connection: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/jdbc/AppianPrimaryDS: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/jdbc/AppianPrimaryDS: javax.resource.ResourceException: IJ000658: Unexpected throwable while trying to create a connection: null: javax.resource.ResourceException: Could not create connection: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host *.*.*.*, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall."
This error is present even when users are able to access SQL Server through SQL Server Management Studio.
SQL Server has not been configured to accept incoming connections on the specified port.
To verify that SQL Server is not listening on that port, run netstat -na | find "<port\>" in the command line. If no results are returned, perform the following:
This article applies to all versions of Appian using Microsoft SQL Server as a database.
Last Reviewed: October 2015
© 2020 Appian. All rights reserved.