A "Connection verification failed for data source" error may occur while attempting to verify a SQL Server data source that connects to SQL Server Express using the default ColdFusion SQL Server JDBC driver.
The full error is as follows:
Connection verification failed for data source: {data source name} java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver] Error establishing socket. Connection refused: connect
The TCP/IP and Named Pipes protocols are disabled by default upon the installation of SQL Server Express.
The default TCP/IP port that SQL Server Express listens on may not be 1433.
To configure a data source for SQL Server Express using the default SQL Server driver, follow these steps:
Keywords:
kb400255
Twitter™ and Facebook posts are not covered under the terms of Creative Commons.
