Purpose

The purpose of this article is to teach you the process of setting up Windows Authentication Mode Security using Enterprise Manager in Microsoft SQL Server 2000.

To Set up Windows Authentication Mode Security

When a user connects through a Microsoft Windows user account, SQL Server validates the account name and password using information in the Windows operating system.

The following steps describe you the step by step details of setting up the windows authentication mode security:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager.

2. Right click the registered SQL Server i.e. PC54, and click Properties.

3. Under Authentication, select Windows only, select an Audit level i.e. All. Also, under Startup service account, select System account.

4. Click OK.