LiveDocs Comments - coldfusion - 6 - Administering_ColdFusion_MX - datasources_ADV_MJS8.htm

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

Christian Gayton — 2006-10-31T08:57:19

SQL Security Tools seems to be the solution
http://www.microsoft.com/downloads/details.aspx?familyid=9552d43b-04eb-4af9-9e24-6cde4d933600&displaylang=en
Worked for me with CFMX 7.02 and SQL 200 sp3a
HTH
Christian

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

2006-07-17T10:39:21

If you get an error like the following and are running MS SQL Server 2000:

Connection verification failed for data source: blogcfcsql []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

Then, your problem can most likely be solved by installing MS SQL Server 2000 Service Pack 4. Somehow, it seems like it has something to do with OLAP engine.

Hope this helps...

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

2006-06-02T08:29:16

All the related topics above lead to case sensitive issues. Make sure that the datasources' names are exactly the way it is displayed in Enterprise Manager. I hope this helps.

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

2006-02-05T02:04:11

if you are using Windows 2003 server and CF MX 7 and MS SQL Server 2000 and get the error message

Error establishing socket. Connection refused: connect

SQLCritUpdPkg.exe file from Microsoft's website (mentioned by robison above)

unzip / install the above package , a folder named SQLCritUpdPkg will be created on your C drive with other folders in it.

from SQLCritUpd folder install SQLHotfix_ENU.exe and proceed with datasource creation in CF MX Administration

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

Swathi_Sathish — 2005-09-23T05:55:09

I faced the same problem today and have been trying various solutions that were given online. Then decided to do something on my own. Just went into CFMX Admin and for all of my SQLServer Datasource Mappings, I just went into the advanced settings and limited the number of connections to just 1. Then stopped the CFMX Server. Next step went into the Enterprise Manager and Selected on my local SQLServer->Properties. There U have an option to set the number of parallel connections. I increased it to 20. U can increase it to UR limit. Then stop the MSSQLServer. Restart MSSQLServer and then restart CFMX Server. Go into Datasources and do a verify all connections and it should all be OK. I even tried restartign my Workstation about 4-5 times. It did not work but this method worked. I dunno how but it worked for me and i hope it does work for U as well.

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

JRowny — 2005-07-15T17:44:04

For those of you who get the error connecting to socket.
I found that my SQL Server (MSDE SP4) actually didn't have the TCP/IP configured at all. All I needed to do was go to properties-> network configuration -> enable TCP/IP and then restart the service.

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

niko1 — 2005-03-19T19:33:13

I know this area is not for support but I think most people will find they can solve this issue by updating MS SQL DBNETLIB.dll. All you have to do is download the MS SQL update tool. I have bloged this information there:

http://www.robisen.com/index.cfm?mode=entry&entry=BE1AB594-55DC-F2B1-F392552E0A41542A

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

2005-03-18T00:47:47

How to connect MSDE 2000 (SQL Server 2000 Desktop Edition) to ColdFusion 6.1 via the ColdFusion administrator?

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

jrunrandy — 2005-03-14T13:34:47

The Troubleshooting discussion in the CFMX 7 documentation has suggestions that might apply to you.

http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001743.htm

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

2005-03-09T15:59:07

When I try to establish a DSN connection via the Administrator, I am greeted with the following message:

Connection verification failed for data source: ows
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Could not establish a connection using integrated security: No LoginModules configured for JDBC_DRIVER_01
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Could not establish a connection using integrated security: No LoginModules configured for JDBC_DRIVER_01

Does anyone have any friendly advice? This has become a 3+ hour uphill battle now....thanks!!

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

Guru_HUITZILOPOCHTLI — 2005-02-26T14:01:54

I had the same problem connecting a local msde. I found that msde does not start it's tcp/ip service by default and I had to go in and start the service and restart the msde.

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

jwlewisii — 2005-01-13T05:14:17

I was getting the same error: "Connection Refused" and noticed that there have been a number of solutions. After trying everyone else's suggestions unsuccessfully - I evaluated my software versions and this is what worked for me:

1. This may not have been necessary - but I uninstalled CF.

2. MS - SQL 2000 is running on Server 2003. I updated the SQL software to service pack 3a. http://www.microsoft.com/sql/downloads/default.asp

3. Then, I updated the SQL SP3 type 4 JDBC driver from Microsoft. http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en

4. I then reinstalled CF server.

I am sure that I could have just updated the driver and been done with it, but was a little desperate.

5. I followed TFerring's steps to create SQL user for the CF user and pass:
"6. Set the Server to 127.0.0.1
7. Create a SQL Login user
a. Expand SQL Server instance -- in my case it was (local)
b. Expand Security tab
c. Right--Click and select New Login
d. Create a new Login called "ColdFusion"(any name will do) and
set the password Triton45%$God
e. Set all the Server Roles and Database Access "

All this is assuming that the SQL properties are set to accept both SQL users as well as Windows users for the particular system the server is running on. With the new updates in place, I was able to run the connection on the default port .

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

tferring — 2004-12-20T21:38:07

I had the same socket problem:
**********
[]java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
**********
I used a few methods mentioned and resolved my problem
MY FIX:
1. I changed the port on the SQL Server-Properties-Network Configuration-Highlight TCP/IP and click Properties- Set the Port to 8433.
2. Click OK
3. RESTART SQL
4. Go to ColdFusion Administrator
5. Use the SQL Northwind database, set the Server to 127.0.0.1, use the ColdFusion Login and password.

6. Set the Server to 127.0.0.1
7. Create a SQL Login user
a. Expand SQL Server instance -- in my case it was (local)
b. Expand Security tab
c. Right--Click and select New Login
d. Create a new Login called "ColdFusion"(any name will do) and set the password Triton45%$God
e. Set all the Server Roles and Database Access
This worked for me...

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

2004-12-13T09:08:49

Hello,

I had this problem (Error establishing socket., WXP SP2)

I uninstalled SP2: it works fine now.

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

2004-12-07T07:04:42

The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

jrunrandy — 2004-11-22T05:08:24

I asked a QA engineer about the "Connection Refused" error message, and this is what he said:
*******
Two things come immediately to mind:

1. They are running SQLServer on W2K Pro (max 10 connections) instead of on W2K Server, and this request is the 11th TCP/IP connection.

2. They have a connection-limited license for SQLServer - and CF is requesting an additional connection beyond their limit.

Both of these problems can be surmounted by setting the Datasource [Limit Connections] and [Restrict connections to] settings in CF Admin (taking into account any other connections which may be present.
*******

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

2003-11-14T08:41:26

I'm having trouble connecting to a data source of a local innstance of SL Server. I get the message:
Connection verification failed for data source: FAD_RAD
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.
I'm running on XP pro. On a differen machine using windows server 2000 I have been successful but now that connection has failed and cannot be re-established. I have followd the insrtuctions on how to make the connection and now I need some information on trouble shooting the issue,
thanks

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

jrunrandy — 2003-11-14T08:38:59

We're sorry, but LiveDocs is for documentation comments only. It is not a source for product support. Please post your issue to the online forums: http://webforums.macromedia.com/coldfusion/

Also, to help us communicate with you better, please use a valid e-mail address when registering with macromedia.com.

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

jrunrandy — 2003-11-10T07:01:31

See http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/dataso12.htm#wp1238785 for Terry's answer to the Northwinds question.

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

Terry Reiber — 2003-11-07T15:55:27

I think its quite pathetic that Macromedia doesn't supply some basic documentation that tells you how to connect to the NorthWind database.

I mean, lets face it, ms sql 2000 is probably the most common server used.

I have yet to find anyone on the internet that can give me the basic settsing for both Enterprise Server and ColdFusion administration to do this task.

Is it just the companies want paid support calls?

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

2003-10-24T01:15:09

this is what I'm getting I have try different options many times but no success

Connection verification failed for data source: movie_dns
[]java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
The root cause was that: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

rhett not butler — 2003-09-07T06:42:26

connecting to a named instance of sql server 2000 named RHETTXP\RHETTXP DOES NOT work with colfusionMX
the arror is inaccessible but all my other sql tools work. even a odbc system data source works fine with RHETTXP\RHETTXP
WHY does NOT this work with macormediaMX server.

I am using server administrator to create a data source

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

HelpMe — 2003-05-13T18:43:00

Connection verification failed for data source: OISConn
I am trying to set an ODBC Socket SQL Server and am getting the following message. Can anyone help?

[]java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.
The root cause was that: java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

Robin Roberts — 2003-04-24T18:05:00

I cannot get past the following error:
Connection verification failed for data source: Northwind
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.

I have tried many options. Does anyone have a clue? Thanks.

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

wrend — 2003-03-11T14:11:00

I have tried this several times, have gone through the steps defined by the docs, and have been unsuccessfull.

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

michaelkang — 2003-01-31T22:03:00

I figured out how to connect to MS SQL Server 6.5.
First, create ODBC on a web server.(This ODBC could points to remote SQL Server.)
Second, create data source on the server inside ColdFusion Administrator web page.
(1) Data Source Name: Whatever you want
(2) use ODBC Socket
(3) Click Add
(4) Choose proper ODBC DSN you created in the First Step.
(5) Click Show Advanced Settings
(6) Username: insert proper one
(7) Password: insert proper one
(8) Connection String:
"Driver={SQLServer};Server=XXX.XXX.XXX.XXX;Address=XXX.XXX.XXX.XXX,1433;Network=DBMSSOCN;Database=XXXXX;Uid=XXXXX;Pwd=XXXXX"
(9) make sure that XXX shoulb be replaced with proper ip address, database name, userid, password in the above string.
(10) click submit

Thank you.

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

rayafanatico — 2003-01-10T13:57:00

Hello, is there a way to make the SQL server driver on ColdFusion MX to work with SQL server 6.5 with Windows NT? Or Do I need another driver?

Thanks

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

MikeFusion — 2002-12-28T00:07:00

If your running SQL Server locally (or using MSDE) use 127.0.0.1 for the server name instead of the actual instance name.

coldfusion/6/Administering_ColdFusion_MX/datasources_ADV_MJS8.htm

sam@serndesign.com — 2002-10-10T21:08:00

It would be nice to list the actual JDBC driver used for each (vendor and version).