Skip to main content
E
elDonrico
Inspiring
April 16, 2008
Answered

CF Admin DSN error

  • April 16, 2008
  • 1 reply
  • 1814 views
Running CFMX 7 on a 2k3 server. Trying to access MS SMS data in an SQL 2k5 server on 2k3...

My system odbc tests successfully using the sql server driver. And with my admin account credentials. In cf Admin datasources, using an ODBC socket driver it will either time out with this error:
Connection verification failed for data source: connSMS2
java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish connection

Or give me a login error:
Connection verification failed for data source: connSMS3
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'domain\servername$'.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'domain\servername$'.




If I use the Microsoft SQL Server driver I get this error:

Connection verification failed for data source: connSMS
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'domain\username'.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user domain\username

Anybody know of maybe why this is going on or a way around it or fix it??

I do not have complete and utter control of the SQL DB, that is higher up than me. but, since the ODBC tests fine, and i can use MS SQL server manager to connect to the db and open tables, create select statements, etc.. one would think there shouldn't be a problem with cf admin's dsn...

thanks.
This topic has been closed for replies.
Correct answer JR__Bob__Dobbs-qSBHQ2
When you say
quote:
run your CF service as a Windows user with access to your database
...

which service are you talking about? ODBC Agent? ODBC Server? App server?

also, if i was to do this, what are the draw backs to running the services as a user as opposed to "Local System"

thanks.
quote:
Originally posted by: elDonrico
When you say
quote:
run your CF service as a Windows user with access to your database
...

which service are you talking about? ODBC Agent? ODBC Server? App server?

also, if i was to do this, what are the draw backs to running the services as a user as opposed to "Local System"

thanks.



If you use a Windows account run the CF and access your database you will need to run the "ColdFusion MX 7 Application Server" service as a specific windows user. Since you will be using Microsoft's JDBC driver you need not alter the ODBC services.

Here an article that lists the required permissions for your windows account to be able to run the service. You should use a strong password for this account and change the password regularly.
I'm not sure there any drawbacks to this approach other than needing to manage another windows account. An advantage is that your CF server can access network resources, such as file shares, which Local System cannot.
http://www.adobe.com/go/tn_17279

See this post for setting up your driver/DSN (this refers to an older version of the driver, but should be appicable to the newest version as well)
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=6&threadid=1206110&highlight_key=y&keyword1=integrated

Driver download from Microsoft
http://www.microsoft.com/downloads/details.aspx?FamilyID=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en

About driver
http://msdn2.microsoft.com/en-us/library/ms378749.aspx

1 reply

J
JR__Bob__Dobbs-qSBHQ2
Inspiring
April 16, 2008
Are you attempting to login with your Windows account info? If so be aware this is not supported by the drivers bundled with CF. You have two options:

1. Enable SQL authentication on your SQL server and connect using a SQL login.
2. Get Microsoft's JDBC driver for SQL server and run your CF service as a Windows user with access to your database.
E
elDonricoAuthor
Inspiring
April 16, 2008
Thanks for the reply, i will try using one of these methods.
E
elDonricoAuthor
Inspiring
April 16, 2008
When you say
quote:
run your CF service as a Windows user with access to your database
...

which service are you talking about? ODBC Agent? ODBC Server? App server?

also, if i was to do this, what are the draw backs to running the services as a user as opposed to "Local System"

thanks.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices