Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling Stored Proc using NT Authentication

Status
Not open for further replies.
tinamo

tinamo

MIS
Joined
Sep 5, 2001
Messages
2
Location
US
Within the CF Administrator (v4.5.1) is there a way to use an NT domain (NT v4.0 SP6a) account to create an ODBC connection to SQL Server (v7.0 SP2).

I know I can use a SQL Server account to create the ODBC connection but unfortunately the database had previously been set up using NT authentication (using a local domain account) and all of the stored procedures are owned by the domain account user ID. When I make a call to the stored procedure using Cold Fusion it can't pass the domain account user ID and password to the database.

Is there a way to work around this issue? At this time, we need to keep the domain account.

Thanks.
 
Status
Not open for further replies.

Similar threads

LyndonOHRC
  • Locked
  • Question Question
Need help using ImageCrop()
Replies
1
Views
341
LyndonOHRC
LyndonOHRC
Mike Lewis
  • Locked
  • Question Question
Using Dreamweaver to maintain a site not created in Dreamweaver
Replies
2
Views
1K
Mike Lewis
Mike Lewis
Boston495
  • Locked
  • Question Question
Can ColdFusion use Windows Authentication to access network shares?
Replies
0
Views
247
Boston495
Boston495
n36z
  • Locked
  • Question Question
cfstoredproc or stored procedure problem
Replies
2
Views
301
n36z
n36z
szeiss
  • Locked
  • Question Question
Rendering Recordset in HTML Using Cfdocument
Replies
2
Views
301
cfSearching
cfSearching

Part and Inventory Search

Sponsor

Back
Top