Skip to main content
J
JohnEric
Inspiring
October 18, 2006
Answered

SQL Server 2005 MS JDBC Driver v1.1 and Integrated Authentication

  • October 18, 2006
  • 1 reply
  • 633 views
In our setup we have MX 7 Standard running on Windows Server 2003 with SQL Server 2005 for a database backend. The CF Server service is running under a specific domain account. Using the Microsoft JDBC Driver for SQL Server v1.1 I am able to connect to the database using a sql server login and specifying the password. I would like to be able to use integrated security to connect to the DB but, I don't seem to be able to specify integrated security. Instead of connecting an error about username '' is invalid.

Has anyone had success connecting to SQL Server 2005 with integrated security?
This topic has been closed for replies.
Correct answer JohnEric
To answer my own question....

Here's how I got this to work.
1. Set the cf service to log on as a domain user
2. take the sqljdbc.jar and sqljdbc_auth.dll files and place them in <cfroot>\runtime\lib
3. Added that directory to the java.library.path in the jvm.config
4. set the datasource up as other with the following settings
JDBC URL: jdbc:sqlserver://<server>;databaseName=<database>;integratedSecurity=true;
Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver Name: SQLServerDriver
Username: blank
Password: blank

The datasources verify and work correctly. I did also update the datadirect drivers as well so I'm not sure if that had anything to do with it either.

http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=42dcb10a

1 reply

J
JohnEricAuthorCorrect answer
Inspiring
June 5, 2007
To answer my own question....

Here's how I got this to work.
1. Set the cf service to log on as a domain user
2. take the sqljdbc.jar and sqljdbc_auth.dll files and place them in <cfroot>\runtime\lib
3. Added that directory to the java.library.path in the jvm.config
4. set the datasource up as other with the following settings
JDBC URL: jdbc:sqlserver://<server>;databaseName=<database>;integratedSecurity=true;
Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver Name: SQLServerDriver
Username: blank
Password: blank

The datasources verify and work correctly. I did also update the datadirect drivers as well so I'm not sure if that had anything to do with it either.

http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=42dcb10a
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices