ColdFusion MX 7 and SQL Server 2005 : Do not connect

Question

Hi

I can create Data Sources for MS Access with ColdFusion MX
7.0 but when I try to connect to SQL Server, it refuses to connect
and just returns timed-out error.

I have a developer Edition of Cold Fusion Mx 7.0 and I even
tried to install JDBC driver for SQL Server and use "Others" option
for the connection in DSN.

Can anyone guide me what could be the issue, I am getting
following error:

Connection verification failed for data source: Test
java.sql.SQLException: Timed out trying to establish
connection
The root cause was that: java.sql.SQLException: Timed out
trying to establish connection

Regards

JohnEric · Answer

What version of windows?What version of sql server?Is it a named instance?Does the SQL Server allow remote connections?Through TCP/IP?Is the SQL Server using mixed mode authentication?Are you trying to use integrated authentication or sql serverauthentication?Which JDBC driver did you install?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded