SQL Server 2005 Help

[Johnny Derk]

I have only used access in the past and am brand new to sql server 2005.

I installed sql server 2005 (developer edition) on my computer and used the
access wizard to create a sql compliant db. I then tried to connect to db
through CF administrator. I got this error. Any suggestions would be helpful. I
enabled tcp/ip connection in the configuration manager, that is the only change
I have made.

This is the error the cf administrator gives me when i verify connection:

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

Any advice would be greatly appreciated.

[philh]

JDBC/ODBC connections normally require mixed security; apparently you've
installed the instance with integrated security only. Also, I don't know that
SQL2K5 is yet certified for use with CF.

There are a couple of threads here about using 2K5; poke around a bit.

Good luck,