Export (0) Print
Expand All

Authentication Mode

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Use this screen to choose the security (authentication) mode you want to use for this installation of Microsoft® SQL Server™ 2000. If you select Mixed Mode, you are prompted to enter and confirm the system administrator password. After successful connection to SQL Server, the security mechanism is the same for both modes.

Options

Windows Authentication Mode

When a user connects through a Microsoft Windows® user account, SQL Server validates the account name and password using information in the Windows operating system.

Security Note  When possible, use Windows Authentication.

Mixed Mode (Windows Authentication and SQL Server Authentication)

Allows users to connect using Windows Authentication or SQL Server Authentication. Users who connect through a Microsoft Windows user account can make use of trusted connections (connections validated by Windows) in either Windows Authentication Mode or Mixed Mode. SQL Server Authentication is provided for backward compatibility.

Add password for the sa login

Enter and confirm the system administrator password.

Blank Password (not recommended)

If a user attempts to connect to an instance of SQL Server providing a blank login name, SQL Server uses Windows Authentication. Additionally, if a user attempts to connect to an instance of SQL Server configured for Windows Authentication Mode using a specific login, the login is ignored and Windows Authentication is used.

See Also

Adding a SQL Server Login

Assigning an sa Password

Authentication Modes

Creating Security Accounts

Show:
© 2014 Microsoft