NT Authentication

• sfm

  Old Hand

  Points: 394

  More actions

  November 18, 2003 at 1:42 am

  #101760

  Hi,

  I am looking into implementing and SQL Server Database with ASP pages and am wondering about authentication. In particular, I was wondering how to implement NT Authentication. Can anyone tell me how this can be done, or point me in the right direction? What are the advantages/disadvantages?

  Thanks for the help.

• meghardy

  Default port

  Points: 1453

  More actions

  November 20, 2003 at 5:12 am

  #482827

  Hi,

  i've just been reading a very interesting article on this site called 'The case for SQL Logins'. it might help you out or help you make sense of things.

  http://www.sqlservercentral.com/columnists/awarren/thecaseforsqlloginspart1.asp

  i'm not too sure on all this stuff but am trying to figure it out!

  good luck...Meg

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  November 21, 2003 at 2:18 pm

  #483234

  Whenever possible, it is considered a best practice to use Windows authentication. The reasons are pretty simple: the SQL Server password doesn't go across the network in plaintext and you can manage security in one place, the domain. With that said, it's not always possible and there are examples where the flexibility of the SQL Server login cannot be ignored (as with Andy's excellent article). Also, it means you don't have to store you're password on the web server.

  Here's how to build the connection string:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/pg_ado_get_data_4.asp

  Here's how to make everything work:

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;176379

  K. Brian Kelley, GSEC

  http://www.truthsolutions.com/

  Author: Start to Finish Guide to SQL Server Performance Monitoring

  http://www.netimpress.com/

  K. Brian Kelley
  @kbriankelley