Jasinski Technical Wiki


Home Page
All Pages

Quick Search
Advanced Search »

Contributor Links

Create a new Page
File Management
Your Profile

Other Wiki Sections



Configuring SQL Server Authentication Mode - SQL Server 2005

Modified on Mon, Oct 27, 2008, 5:15 PM by Administrator Categorized as SQL Server
SQL Server has two authentication modes.

  • SQL Server Authentication - users exist only in the context of the SQL Server
  • Windows Authentication (also called Integrated Security) - Windows NT user accounts are granted permissions to SQL Server securables.

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.

ScrewTurn Wiki version Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.