Cold Fusion and SQL Server authentication

Posted on 2002-04-19
Medium Priority
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?
Question by:geowilli
  • 2

Expert Comment

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


Author Comment

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?

Accepted Solution

winningl earned 150 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.


Author Comment

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?

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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.

Join & Write a Comment

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
Whether you have a site with just static html pages or a dynamic database-driven one, this step-by-step migration guide will help you get started with your new DV server. This guide is by no means comprehensive but it should cover the basics to get …
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…

623 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