Solved

Cold Fusion and SQL Server authentication

Posted on 2002-04-19
4
255 Views
Last Modified: 2013-12-24
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
Comment
Question by:geowilli
  • 2
4 Comments
 
LVL 5

Expert Comment

by:Yog
ID: 6954721
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
 
LVL 1

Author Comment

by:geowilli
ID: 6954809
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
 
LVL 3

Accepted Solution

by:
winningl earned 50 total points
ID: 6954915

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
 
LVL 1

Author Comment

by:geowilli
ID: 6954946
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

Don't miss ATEN at NAB Show April 24-27!

Visit ATEN at NAB Show to learn how our "Seamlessly Entertaining" solutions deliver fast, precise video streaming without delays for the broadcasting and media environment. ATEN will showcase its 16x16 Modular Matrix Switch (VM1600) and KVM Over IP Solution (KE6900 series).

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question