Setting the Authentication Mode

5/10/2007

SQL Server 2000 and SQL Server 2005 provide the following two methods for authenticating logins:

  • Windows Authentication: SQL Server 2000 and SQL Server 2005 security is integrated directly with the Windows operating system security, allowing the operating system to authenticate SQL Server 2000 and SQL Server 2005 users.
  • SQL Server Authentication: The administrator creates SQL Server login accounts within SQL Server 2000 or SQL Server 2005, and any user connecting to SQL Server 2000 or SQL Server 2005 must supply a valid SQL Server login name and password.

Windows XP Embedded requires Windows Authentication. SQL Server supports mixed-mode authentication, which allows for both Windows Authentication and SQL Server Authentication. The database installation may prompt you to change to the required authentication mode if the installation was configured for SQL Server Authentication only.

To set the authentication mode

  1. Start SQL Server Enterprise Manager from the Start menu.

  2. Expand the Microsoft SQL Servers node, and then expand the SQL Server Group node.

    Your database server registration is located under this node.

  3. Right-click the <database server registration> node, and then choose Properties.

  4. In the SQL Server Properties dialog box, select the Security tab.

    The current authentication mode is displayed in the Security group box.

  5. Choose Mixed mode authentication, and then choose OK.

  1. Start SQL Server Enterprise Manager from the Start menu.

  2. Expand the Microsoft SQL Servers node, and then expand the SQL Server Group node.

    Your database server registration is located under this node.

  3. Right-click the <database server registration> node, and then choose Properties.

  4. In the SQL Server Properties dialog box, select the Security tab.

    The current authentication mode is displayed in the Security group box.

  5. Choose Mixed mode authentication, and then choose OK.

See Also

Tasks

Administering a Shared Database