Yeah - I read that too.... but I still don't know anyone using CFMX with native security.
A couple things to try on the server end. Set up an alias using the client network utility. Since it's SQL 7 you may need to enable "named pipes" on the web server using the client network utility. I don't beleive that CF 7 allowed tcp/ip native authentication - it needed a higher level ipc. Log into the desktop of the web server (using rdp or whatever) as the same user running cf and then use query analyzer to try and connect to the alias with the "windows authentication" checked. Make sure CF is running as a service and on a domain account (sounds like you already did that one). There were lots of gotchas with SQL 7 security. Remember it pre-dates Win2000, so get ready to spend some time fiddling Nero :) -Mark -----Original Message----- From: Russ [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 2:17 PM To: CF-Talk Subject: RE: cf7 sql server integrated security It's supposed to be natively supported with the new JDBC drivers as per this technote: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=1a3c2ad0 -----Original Message----- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 12:41 PM To: CF-Talk Subject: RE: cf7 sql server integrated security Russ, Sorry ... on cfmx it's going to be a real hack if it's possible at all :) -----Original Message----- From: Russ [mailto:[EMAIL PROTECTED] Sent: Friday, September 09, 2005 11:35 AM To: CF-Talk Subject: RE: cf7 sql server integrated security So is nobody using this configuration? -----Original Message----- From: Russ [mailto:[EMAIL PROTECTED] Sent: Thursday, September 08, 2005 6:20 PM To: CF-Talk Subject: cf7 sql server integrated security I am trying to connect to sql server using integrated security. so both my cf and sql servers are in a domain (cf is the dc, and sql is the backup dc). I have set up a database, and added the account that cf runs under to have full permissions to the database. I am trying to use integrated security, so I installed the latest cf hotfixes including the jdbc drivers. I added AuthenticationMethod=Type2 into the connection string field per the technote. However when I try to verify the datasource, I keep getting Connection verification failed for data source: a java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]A username was not specified and the driver could not establish a connection using type 4 integrated security: No LoginModules configured for JDBC_DRIVER_01 The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]A username was not specified and the driver could not establish a connection using type 4 integrated security: No LoginModules configured for JDBC_DRIVER_01 What am I doing wrong? Has anyone set this up to work successfully with cf 7? Russ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217863 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
