Previous Topic: How User Authentication Is ChangedNext Topic: Update the Agent Account Configuration

Configuring Microsoft SQL Server Security Settings › How User Authentication Is Changed › Check or Change the Microsoft SQL Server Authentication Method

Check or Change the Microsoft SQL Server Authentication Method

To check or change the Microsoft SQL Server authentication method for SQL Server 7.0 or 2000

  1. On the system where Microsoft SQL Server is running, open the SQL Server Enterprise Manager.
  2. In the Tree pane, expand the entries below Console Root until you reach the instance of the database server.
  3. Right-click the instance and select Properties from the drop-down list. The Properties dialog opens.
  4. In the Properties dialog, choose the Security tab.
  5. Under Authentication, select either Microsoft SQL Server and Windows to enable Microsoft SQL server-based authentication or Windows Only to enable only Windows user names and passwords.
  6. Click OK.
  7. Restart the SQL Server instance for the changes to take effect.

To check or change the Microsoft SQL Server authentication method for SQL Server 2005, 2008, and 2012

  1. On the system where Microsoft SQL Server is running, open the SQL Server Management Studio.
  2. Connect to the instance of Microsoft SQL Server that you want to change.
  3. In the Object Explorer pane, right-click the instance and select Properties from the drop-down list. The Properties dialog opens.
  4. In the Properties dialog, choose the Security page.
  5. Under Server Authentication, select either SQL Server and Windows Authentication Mode to enable Microsoft SQL Server-based authentication, or Windows Authentication Mode to enable only Windows users.
  6. Click OK.
  7. Restart the SQL Server instance for the changes to take effect.