Skip to main content
Participant
May 23, 2007
Answered

SQL 2005 datasource error--LoginModules

  • May 23, 2007
  • 1 reply
  • 820 views
ColdFusionMX7 & SQL server 2005 running on T60p IBM Thinkpad under Windows XP sp2....after ensuring sql confiq allows TCP/IP and mixed auth chosen...Unable to create datasource in Admin to SQL 2005 database, returning error: "No LoginModules configured for JDBC_Driver_1"

I didn't see anything in either the forums or knowledgebase about this. Any ideas?

charlie cousins out of NE Washington, where the skies are finally blue
This topic has been closed for replies.
Correct answer lazyacres
Doh!

I downloaded the macromedia_drivers.jar update from Adobe and installed per instructions.

Problem solved. Hope this helps someone in the future.

1 reply

Participating Frequently
May 24, 2007
I would verify again that TCP/IP is enabled and that both SQL Server and Windows NT Authentication are enabled. See http://www.forta.com/blog/index.cfm/2006/1/10/ColdFusion-And-SQL-Server-2005

Ted Zimmerman
lazyacresAuthor
Participant
May 24, 2007
The TCP/IP is enabled and the server is set for mixed mode auth. I believe this particular issue is java-related, since LoginModule appears to be a function or method. And it may be related to the arcane security built into my rig by IBM (embedded security chip and all that). I've tried installing the sqljdbc.jar driver from MS--but no luck with that, either.

One reply to Ben Forta's post in January did reference the same problem, but I didn't see any followup on that.

I have no problem building ODBC or connecting to various SQL 2005 db's out of various parts of VS2005, but then I'm not using TCP as the approach there or a java-based product as the connection point.
lazyacresAuthorCorrect answer
Participant
May 24, 2007
Doh!

I downloaded the macromedia_drivers.jar update from Adobe and installed per instructions.

Problem solved. Hope this helps someone in the future.