JM
>> Try as I might, I cannot get CF to connect to SQL Server in
>> "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]
