CF Admin DSN error

[elDonrico]

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.

[JR]

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.

[elDonrico]

Thanks for the reply, i will try using one of these methods.

[elDonrico]

When you say [Q]run your CF service as a Windows user with access to your
database[/Q]...

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.

[JR]

[q][i]Originally posted by: [b][b]elDonrico[/b][/b][/i]

thanks.[/q]

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 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&t
hreadid=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

[elDonrico]

Thanks Bob,

works perfectly now. this article also helped me out...
http://kb.adobe.com/selfservice/viewContent.do?externalId=42dcb10a&sliceId=2

thanks again.