Configuring SQL Server Authentication Mode - SQL Server 2005
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.
In the
SQL Server Management Studio Object Browser
, right-click the database server of interest and select
Properties
.
In the
Server Properties
window, select the
Security
page.
Under
Server Authentication
, selected the appropriate authentication mode.