Configuring SQL Server Authentication Mode - SQL Server 2005

SQL Server has two authentication modes.

To set the Authentication Mode, execute the following procedure.
  1. In the SQL Server Management Studio Object Browser, right-click the database server of interest and select Properties.
  2. In the Server Properties window, select the Security page.
  3. Under Server Authentication, selected the appropriate authentication mode.