> "Windows Only" security mode with specially created accounts
> or even the sa account. I ask because it is considered a
> security best-practice to enforce Windows-only security in
> SQL Server, but obviously I need CF to work.
>
> If I switch to mixed-mode, it works fine. Am I missing
> something here? Can CF only connect if mixed-mode security
> is enabled in SQL Server?
Yes, the MS SQL Server JDBC driver in CFMX requires native SQL logins and
can't use Windows authentication. If you must use Windows authentication,
you may be able to use the ODBC Socket, but I'd recommend against this.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
