Getting error to create the database source

[Creative mind]

hi Guys,
Would u like to help me. I m getting an error to create the
database source for MS SQL Server Database.

The Information, what I m providing.

CF Data Source Name : myDSN
Database : Blues
Server : local
Username:
Password :

or

CF Data Source Name : myDSN
Database : Blues
Server : 127.0.0.1
Username:
Password :

or

CF Data Source Name : myDSN
Database : Blues
Server : (local)
Username:
Password :

or

CF Data Source Name : myDSN
Database : Blues
Server : "local"
Username:
Password :


These all options, I tried but getting the same error.

The Error is :

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

I have check the port no also. It is fine.

I will really appreciate your help

Bluesim


:|

[gclausen]

The error you're getting says it can't connect to either the machine or the SQL
Server instance.
Is the SQL Server running on the same machine as CFMX? If so the "Server"
should be "localhost" or the IP Address of the machine. Otherwise the IP
Address will work.
I don't think it's having a problem finding the database but I believe the
"pubs" database comes with every instance of SQL Server, try using "pubs" for
the "Database" property.