I'm using Coldfusion MX7.0.2 on Windows 2003 SP1. I've installed and set up
the Microsoft SQL Server 2005 JDBC driver, and have successfully set up a
datasource using Windows Authentication (I have no user/password assigned in
the datasource configuration; it's passing the ColdFusion service
I'm using Coldfusion MX7.0.2 on Windows 2003 SP1. I've installed and set up
the Microsoft SQL Server 2005
JDBC driver, and have successfully set up a datasource using Windows
Authentication (I have no user/password
assigned in the datasource configuration; it's passing the ColdFusion
I tested a little bit further by going into SQL Server Management Studio and
removing permissions to the database for the ColdFusion service login account.
When I attempt to run the query, it does attempt to use the username I'm
passing, but then gives me an error:
Cannot open database GDI
Server JDBC Driver and Authentication
I'm using Coldfusion MX7.0.2 on Windows 2003 SP1. I've installed and
set up the Microsoft SQL Server 2005 JDBC driver, and have
successfully set up a datasource using Windows Authentication (I have
no user/password assigned in the datasource configuration
username/password, in the DSN settings.
Then, your CF code should override, if it works.
Mike
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2008 1:03 PM
To: cf-talk
Subject: RE: Microsoft SQL Server JDBC Driver and Authentication
You can use
PROTECTED]
Sent: Thursday, December 04, 2008 12:54 PM
To: cf-talk
Subject: Re: Microsoft SQL Server JDBC Driver and Authentication
I tested a little bit further by going into SQL Server Management Studio
and removing permissions to the database for the ColdFusion service
login account. When I
Ooops. I missed a critical part of your message. You said you did
get Windows Authentication to work, but you want to specify individual
credentials, per query.
Sorry for the confusion.
However, one thing you may try is create a domain group, then grant
database access to that group. In that
The only reason I was even trying this was to ensure secure access to a
particular database
that only certain users have permissions to write to. I guess I'll have to
manage the
permissions through my CF application, rather than at the SQL Server level.
Is this how most
developers deal
8 matches
Mail list logo