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 incfquery.
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:
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://[dbserver]:1433;databaseName=pubs; SelectMethod=direct;sendStringParametersAsUnicode=false; MaxPooledStatements=0;AuthenticationMethod=Type2;
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.