Data Source Connection Verification Fails

[jeenic]

I have been trying for hours to get Cold Fusion admnistrator to accept my data
souce. I am using SQL Server 2000 on my development computer. Databse is called
cpr4dem. I have set up the following: CF Data Source name: cpr4dem Database:
cpr4dem Server: 127.0.0.1 Port: 1433 Username/Password: for this and the
PW I have tried the ID/PW for the database used on my remote server, the ID/PW
for my laptop that I'm working on, and no ID/PW - all give me the following
same error: Connection verification failed for data source: cpr4dem
[]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

[javabuzz]

This is courtesy of Bill_Sahlas, frequent poster. I had the same
problem and this solved it.
(Although I was not trying to use ODBC Socket who cares I just wanted
to get connected on my DEV box)

"Try going back to the begining. Create the System DSN from within the
ODBC control panel through windows and call it MyTest and verify that
this works using the Test Connection Button.

Then in CFAdmin create a new datasource using "ODBC Socket" type
driver. Call it MyTestConnection and then pick "MyTest" from the ODBC
DSN dropdown list. Fill out the rest {Trusted Connection checked if
TRUE and not checked if FALSE; Username, Password} hope this helps."

[brinaldi]

I am getting the same issue on my machine. I have verified using the Windows
data link properties to test the datasource properties that everything is
correct, but I am unable to get MX7 to connect with SQL (same error message
stated above).

[brinaldi]

Coincidentally, Doug Hughes posted the fix to this issue on his
[url]http://www.microsoft.com/downloads/details.aspx?familyid=9552d43b-04eb-4af9-9e24[/url]
-6cde4d933600&displaylang=en#filelist and download the SQL update tool.
Once installed, the problem went away.:D

[CCubes Solutions]

Your best bet is to try this procedure against the NORTHWINDS database that
comes with the MS SQL 2000 installation. Here's how I did it with the MS SQL
2000 Developer Edition software:

Here is some instructions:
1) In ColdFusion Administrator, use NORTHWIND as the data source.
2) Use NORTHWIND as the database.
3) Use 127.0.0.1 as the Server
4) Use 1433 as the port number

Okay, now here's the TRICKY part. Supplying the USERNAME and PASSWORD.
5) In SQL Server Enterprise manager, expand the server group.
6) Then expand the Server
7) Under the Security folder, right click on Logins.
8) Select New Login
9) Click on SQL Server Authentication button and specify NAME (make up
anything you want and specify PASSWORD. This name and password will become your
USERNAME and PASSWORD in Coldfusion Administrator when you try to set up your
Data Source.
10) While in the SQL Server Login Properties box, also specify the database,
this will be NORTHWIND and specify language ENGLISH.
11) Make sure your server is using mixed authentication. While in Enterprise
Manager, right click on the server, select Properties, then Security and
select Security tab. Make sure SQL and Windows radio button is clicked.
12) Okay, with the above information, you should be able to get an OKAY button
when you register the Datasource Name.

if you have questions,
my email is [email]Abdullah_Akbarsaitn@hotmail.com[/email]