mx7 connection to sql database

[macandmo]

I cannot connect mx7 to sql server 2000 database...........the error I am
getting is.

Connection verification failed for data source: apl
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

[mpwoodward *TMM*]

Likely this is because you don't have your SQL Server instance set up to
accept SQL Server logins. If you have it set to use Windows login or a
trusted connection then you'll have problems getting CF to connect.

Matt

--
Matt Woodward
mpwoo...@gmail.com
Team Macromedia - ColdFusion

[macandmo]

thanks Matt

but have since original posting, updated macromedia_drivers.jar file, this
update allows to connect using windows authentication...
I still cannot connect, but, now I am getting this error:-

Connection verification failed for data source: apl

java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish
connection

If you have any ideas, I will be very grateful

Thanks

[mpwoodward *TMM*]

Unless you've changed the user CF runs as on the server, Windows
authentication won't work I don't believe. Use regular SQL
authentication and you'll be fine. There may be a way to use Windows
authentication but I've never done it, and I can't imagine how it would
work on the CF side unless you change the user CF runs as to one that
the SQL Server recognizes.