> connects to the sql server with integrated windows
> authentication. When you launch the application window, it
> authenticates the user against the windows login.
Would you want your web application to work the same way, anyway? It'll be
used by multiple users, and I don't think it's possible to pass the user's
Windows account information to SQL Server for logins, even if you could use
trusted connections with CFMX.
> I am working on a project that replaces this desktop client
> application with a web frontend application. The desktop
> application is configured to only work if the sql server
> authentication is set to 'Windows only'. Both the
> applications are meant to connect to the same sql server.
> Because of the way the sql server is configured (ie windows
> only authentication), I can't get ColdFusion to validate the
> datasource name with a windows login username.
You will need to enable native SQL logins ("untrusted connections") to use
CFMX with your database, currently, since CFMX doesn't support trusted
connections. This may be changed in the future, I suppose, since the
underlying database drivers do support trusted connections.
But that still won't solve your problem, as I hinted at above. If you could
use trusted connections, they would be authenticated using the CFMX server
account, not the accounts of your end users. Currently in CFMX, there's no
way to impersonate another user - the CFIMPERSONATE tag was removed from
CFMX.
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]
