> What you already know is that the SQL server authentication
> is set to 'Windows only' because of the reasons I mentioned
> in my earlier post. Since CF does not currently support
> trusted connections, validating a datasource connection fails.
>
> ...
>
> When you say I will need to enable the native sql logins, do
> you mean "iuser" logins? There are a couple of iuser logins
> that already present on the server

No. Within the database server, you need to enable untrusted connections.
Or, you could try to use trusted connections with the DataDirect 3.3 drivers
by building your own JDBC URL. However, if you do that, you will not be able
to pass authentication information within your datasource settings or your
CFQUERY tag. Instead, you will have to run the CF server itself as a user
with the appropriate rights to the database.

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]

Reply via email to