Go Premium for a chance to win a PS4. Enter to Win

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

Windows NT or Mixed Mode authentication for MS SQL on a web server using coldfusion?

From what I have read it seems that Windows NT Authentication is the way to go, can anyone confirm this? I have been trying to setup NT auth however im having trouble getting it to work correctly. I have a good understanding of MS SQL but limited knowledge on windows 2000 security side of things. If anyone know of any articles or can give me some pointers specificaly dealing with MS SQL, Windows 2000, IIS and Coldfusion that would be very helpful.
0
rot299
Asked:
rot299
2 Solutions
 
Cyber-DudeCommented:
Great article for you to refer:
http://www.winnetmag.com/Articles/Index.cfm?ArticleID=23035

Cyber
0
 
gexenCommented:
At my job, we assign individual passwords for the SQL server.  That way people can login even if they aren't logged in with the exact same username and password on their side.  Windows Authentication is too constrictive for our needs.
0
 
rot299Author Commented:
Thanks. I realise now that I will need to use SQL usernames/passwords as different logins will be needed for users depending on what part of my application that are using.
0

Featured Post

Put Machine Learning to Work--Protect Your Clients

Machine learning means Smarter Cybersecurity™ Solutions.
As technology continues to advance, managing and analyzing massive data sets just can’t be accomplished by humans alone. It requires huge amounts of memory and storage, as well as high-speed processing of the cloud.

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