Quick Search

Advanced Search »

Discuss (0) History

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.

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.

Jasinski Technical Wiki