ACK... my bad, the only way to do Trusted connections is by using the JDBC:ODBC Bridge in CFMX. (You have to set up a SQL Server ODBC connection on the server).
Sorry for the confusion... need more coffee... Jeff ----- Original Message ----- From: "Jeff Garza" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 03, 2003 8:54 AM Subject: Re: CFMX DSN woes Actually, you can use trusted connections (Windows Authentication) with SQL Server, however CFMX will only connect using the account that it is running as. We have Domain level service accounts for all our CFMX installations. If you want to use a Trusted Connection you have to run CFMX as a named user. System (which is the Default for CFMX) cannot participate in a domain or any network sharing for that matter... Otherwise Mike is correct. You have to enable SQL Server logins. As for Oracle... ??? Don't work with it. Jeff ----- Original Message ----- From: "Mike Townend" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 03, 2003 8:38 AM Subject: RE: CFMX DSN woes CFMX will only connect to SQLServer databases setup for SQL Server logins... What happens if you try to set the DB up through the sa account? -----Original Message----- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, March 3, 2003 15:36 To: CF-Talk Subject: CFMX DSN woes I cannot for the life of me configure a DSN in the CF MX Administrator. I have tried to configure both an Oracle Native DSN (on a remote server) and an MS SQL Server 2000 DSN (on localhost) and get this error: Connection verification failed for data source: cm []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Interestingly, I get the same error for both the Oracle DSN and the MS SQL Server DSN. I have updated the JET and MDAC, and have run Updater 2. I am running MX Enterprise on localhost running the built-in web server on port 8500. Right now, I need to get the SQL Server DSN up and running. It gives me this error whether I have the database set up for no security or for a DB User with appropriate rights, and a userid/password assigned. I am using the following settings: DSN: cm database: cm (this is a database in my local instance of SQL Server) server: (local) port: 1433 username: system OR cm (system with only windows security set, cm with SQL Server auth set) password: [none] or "password" Everything else is default except I have Unicode enabled in the "String Format" checkbox and I have CLOB enabled. Can someone help me? Oddly, Access DSN's work fine. Thanks, Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
