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?
LVL 1
geowilliAsked:
Who is Participating?
 
winninglConnect With a Mentor Commented:

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
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.