SQL Server Windows Authentication

• Jagan Kumar

  SSC Eights!

  Points: 805

  More actions

  March 2, 2004 at 9:07 pm

  #82334

  Hi,

  We installed SQL server 2000 Enterprise server with Windows Authentication Mode instead of Mixed Mode.

  I have the following questions.

  SQL Server 2000 installed with Windows Authentication mode doesn't support SQL server Authentication? SQL server authentication works only in Mixed Mode?

  Please help

  -Jag

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  March 2, 2004 at 9:23 pm

  #496802

  From BOL. I think u will get ur answer from this

  Authentication Modes

  Microsoft® SQL Server™ can operate in one of two security (authentication) modes:

  • Windows Authentication Mode (Windows Authentication)

    Windows Authentication mode allows a user to connect through a Microsoft Windows NT® 4.0 or Windows® 2000 user account.

  • Mixed Mode (Windows Authentication and SQL Server Authentication)

    Mixed Mode allows users to connect to an instance of SQL Server using either Windows Authentication or SQL Server Authentication. Users who connect through a Windows NT 4.0 or Windows 2000 user account can make use of trusted connections in either Windows Authentication Mode or Mixed Mode.

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  March 4, 2004 at 11:08 am

  #497357

  You always have Windows auth, you can add SQL auth (with mixed mode).