[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

Cold Fusion and SQL Server authentication

I am in the process of setting up an SQL server database and I plan to use Windows NT Integrated security.
I know this will work fine for clients logged in from workstations.  What setting do I need to place
in my ASP or Cold Fusion pages to access the database since the web server will not be logging into
the NT network per se?
0
geowilli
Asked:
geowilli
  • 2
1 Solution
 
YogCommented:
if any asp or coldfusion pages, you need to go to IIS and remove the Anonymous access under Security. Then for each and every page it will prompt the Windows dialog for the user to enter his username and password

0
 
geowilliAuthor Commented:
Is there no other way?  This is for a customer web site and customers will not have a system account.  Does this mean I need to go back to SQL server security?
0
 
winninglCommented:

Use a session variable. When the client logged into your system, then use the session.username and session.password to connect to your database from each page.

winningl
0
 
geowilliAuthor Commented:
Is there no other way?  This is for a customer web site and customers will not have a system account.  Does this mean I need to go back to SQL server security?
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now