<div>
check the datasource. SO go to CF Admin and verify database connection from there . Make sure that the correct SQL driver is chosen
</div>


check the datasource. SO go to CF Admin and verify database connection from there . Make sure that the correct SQL driver is chosen

<div>
<div class="content wysiwyg-content">
I have Port 1433 open on the firewall for connectivity between a internal Coldfusion server and external MS SQL server. &nbsp;However, the end user is receiving the following error message whenever trying to connect his Coldfusion server to the external MS SQL server. &nbsp;Any idea if this is a firewall issue of an SQL problem?<br />
<br />
Connection verification failed for data source: iMIS_SEMCOG_Dev<br />
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect<br />
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect<br />

</div>
</div>


I have Port 1433 open on the firewall for connectivity between a internal Coldfusion server and external MS SQL server.  However, the end user is receiving the following error message whenever trying to connect his Coldfusion server to the external MS SQL server.  Any idea if this is a firewall issue of an SQL problem?

Connection verification failed for data source: iMIS_SEMCOG_Dev
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


Opening ports between Coldfusion server and external MS SQL Server

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.

Web Servers

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.