creating DSN in CF MX 7 to SQL Server 2000 SP4 db

[Richard Dryfist]

I have a fresh install of CF and IIS and SQL on Win 2003 Server. When I try to
set up a Datasource using the CF Admin panel to my database I get:

java.sql.SQLException
Could not establish connection using integrated security
No login modules configured for JDBC_DRIVER

The database server uses Windows authentication, not mixed authentication (no
sa logn and password).
I was able to create a System DSN on the server jsut fine, and Enterprise
Manager on my laptop can see the database on the server just fine too. CF is
running on the server just fine too. I just can't get a DSN setup in the CF
Admin console.

HELP?

For speed: 206.682.8574 or [email]dkramer@riverswest.com[/email]

[speedpedal]

Richard,

First of all, I will assume that you are refering to "Cold Fusion MX (atleast
version 6.1)". To use windows authentication, do the following:

* Update your DataDirect drivers. Follow this technote:
[url]http://www.macromedia.com/go/42dcb10a[/url]

then follow these:

----------------------------------------------------------------------
SQL Server NT authentication users (Windows Authentication)

These JDBC drivers support SQL Server NT authentication, designated as "type
2". Macromedia expects this feature will replace the less robust
ODBC/Sequelink/ODBC Socket Server solution for many users requiring SQL Server
NT Authentication on Windows platforms

Use of the JDBC NT authentication feature requires a shareable library,
DDJDBCAuth.dll. Place this DLL in the same directory as macromedia_drivers.jar.
A server restart is required.

To use NT authentication, leave both the username and the password blank, in
both the data source and in cfquery.

When ColdFusion or JRun is started from the command prompt, the login
credentials for the command prompt user are used. If ColdFusion or JRun is
started as a Windows service, the credentials of the Windows service will be
used for authentication. It is not possible to specify a Windows account at the
time of the query.

To enable NT Authentication, add the following to the JDBC URL:

AuthenticationMethod=Type2

For ColdFusion MX 7, AuthenticationMethod=Type2 can be added to the URL in the
Advanced Settings > Connection String box.

For ColdFusion MX 6.1, create an "Other" data source with the following
parameters (example):

URL: (enter as one line)
jdbc:macromedia:sqlserver://:1433;databaseName=pubs;
SelectMethod=direct;sendStringParametersAsUnicode= false;
MaxPooledStatements=0;AuthenticationMethod=Type2;

Driver Class:
macromedia.jdbc.MacromediaDriver

For queries that do not require NT Authentication, supply a username for the
query. If a username is specified, SQLServer username/password authentication
is used. SQL Server should be configured for mixed authentication in this case.
----------------------------------------------------------------------

Hope this helps.