Skip to main content
Z
zac1234
Inspiring
February 18, 2008
Question

cfmx 7 wont connect to MS SQL server

  • February 18, 2008
  • 2 replies
  • 670 views
Hi there, can anyone give me some help with connecting to a DB in MS SQL Server? i'm trying to connect via the cfadmin but i keep getting the following error when verfiying the DB connection:

Connection verification failed for data source: sitedirector
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
This topic has been closed for replies.

2 replies

Z
zac1234Author
Inspiring
February 28, 2008
thanks for the reply, i actually worked out that i needed to switch to sql auth instead and it all works fine now, thanks
J
JohnEric
Inspiring
February 27, 2008
It looks like you are trying to connect to SQL Server using integrated security (windows authentication). In this instance you need to make sure that the service that runs CF is logged in as a windows user that also has access to the SQL Server. There's a notice somewhere on the adobe site detailing what you need to do to use integrated security with the CF datadirect jdbc drivers.

What version of SQL Server?
What version of CF?
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices