Help with SQL Server 2005 DataSource

Kent, I see that many others have reported that error (doing a google search), but I see no ready answers. I saw something that reminded me of a connection string value that I've seen answer some problems. May be worth a shot for you: try adding this string to the connection string (in "advanced options") for your datasource:

AuthenticationMethod=Type2

If it doesn't solve it, remove it. But keep it handy in case it ever may help with some other problem.

Here's one other possible answer for you:

http://www.webmasterkb.com/Uwe/Forum.aspx/coldfusion-server/3206/SQL-Server-2000-Windows-Auth

Sorry I can't be more clear for you.

Thank you for the response. This is the error I receive:

Connection verification failed for data source: RMT
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

I will look over the site you provided and see if I can check the SQL Server Databases settings with the admin. Any other thoughts/suggestions on this error would be much appreciated.

Thank you.

Are you successfully connecting from CF to that SQL Server already (other datasources working)? If not, then it may be that you can't connect to SQL Server at all. You haven't offered the error you got. What is it?

Here's one possible error that a lot of folks get, with solutions:

http://carehart.org/blog/client/index.cfm/2006/7/8/sql2k5_Error_establishing_socket

It's the most visited of all blog entries I've ever done, so it seems to be something that many are pointed to.

If that's not it, please report what your error is.