> web server is independent of it. There are ODBC connections
> from the web server to the SQL server. The sql server
> authentication is set to 'Windows only'. I was reading
> somewhere that ColdFusion MX does not yet support trusted
> connections while using the available JDBC drivers and cannot
> connect to databases requiring trusted connections. To permit
> CFMX to connect to the database using the SQL Server JDBC
> driver, one is supposed to configure the database
> authenication to permit "SQL Server and Windows". I'm told by
> the network guys that I'm not suppose to change this. What
> options am I left with? I'll apprecaite your help
You will have to tell the "network guys" that you need to enable native SQL
logins if you want to use CF. You can secure the connection between your web
server and the database server using IPsec, if you're concerned about
security. Unfortunately, while the latest DataDirect drivers supplied by
Macromedia do support trusted connections, CF itself doesn't give you a way
to enable this, and even if you did, your CF server itself would have to run
as a Windows user with rights to all the databases used by your server.
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] [Donations and Support]
