Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Configuring SQL Server Authentication Mode - SQL Server 2005

RSS
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 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.