Purpose

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

To set up Mixed Mode security

Mixed mode allows users to connect using Windows Authentication or SQL Server Authentication. Users who connect through a Microsoft Windows user account can make use of trusted connections (connections validated by Windows) in either Windows Authentication Mode or Mixed Mode. SQL Server Authentication is provided for backward compatibility.

Following steps describe you the step by step details of setting up mixed mode security:

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

2. Click Security tab.

3. Now, select SQL Server and Windows under Authentication, and select an Audit level i.e. All. Also select System account under Startup service account.

4. Click OK.