CF8 Enterprise and MS SQL Server

["Libby H" <webforumsuser@xxxxxxxxxxxxxx>]

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?