CF8 Enterprise and MS SQL Server

[Libby_H]

I need to port a CF8 Enterprise applcation off an MS Access DB to an existing MS SQL Server database/environment (I guess I am technically piggy-backing my database into an existing 'instance'). I have created my SQL Server database, loaded it from the old Access database, and am now looking to connect to it from the CF Administrator.
I am receiving the "java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection." error. I've left the id and password fields blank, thus causing this error. I've checked, and the server properties (using SQL Sever Enterprise Manager) and validiated that it is set for mixed mode authentication (both SQL Server and Windows), but can't get any further.
Any ideas?

[JR__Bob__Dobbs-qSBHQ2]

Are you wanting to use SQL authentication or Windows authentication? If SQL you need to provide the username and password for a SQL login.

[miarte]

I'm having the same problem. The only difference is I'm trying to connect to SQL server on a Guess Windows XP using VMWare Fusion on the Mac with Leopard.

I'm selecting the driver MS SQL Server from the drop down when creating a new DSN to connect to the DB.

I verified the authentication login for windows and SQL and still have the same results.

[johnab]

guys,
this problem always comes down to the SQL server. By default TCPIP connections are not enabled with 2005 so you need to edit the configuration of the SQL server to permit TCPIP and make sure it's listening on port 1433

here are a few links that should help,
http://www.mattwoodward.com/blog/index.cfm?event=showEntry&entryID=01930619-FD0A-4F02-31B1BFC7D1D9A4...

[miarte]

Yeap, it always come down to SQL server.

I was able to connect using the IP address on VMWare Fusion and not with the server name.

Anyway, thanks.
~Cheer

[Libby_H · Accepted solution]

I was able to verify that SQL Server was using mixed mode authentication (both Windows and SQL Server), and that TCP/IP was enabled and using port 1433.
I had to establish a local ID within SQL Server and then used that ID/password combination in the configuration of the datasource within the CF Administrator. And then Bingo, that worked.
Thanks everyone for you suggestions and patience. Oh, and I also purchased a SQL Server 2000 book to help me get through the necessary code changes between MS Access and MS SQL Server.