How to set SQL server to use mixed mode authentication

Introduction

This topic explains how to set SQL Server 2005 to mixed mode authentication.

•  If you have a 2008 instance of SQL installed, please be advised that there are no significant differences between the two interfaces.

1. Click Start, Programs, Microsoft Server 2005, and then click SQL Server Management Studio Express.

2. The connect box will be displayed. Under normal circumstances, the user will be able to click Connect without changing anything here:

3. If the IRIS database has been created in an ‘instance’ other than machinename\IRISPRACTICE (the default), then that instance will have to be selected at this point.

•  If the instance name is not known, log into IRIS, click Help, select About, and then click the Details tab.

4. Once connected, the Microsoft SQL Server Management Studio screen displays. Right-click on the SQL instance name, and select Properties.

5. On the left-hand side newly opened window, select Security, and then select the option labelled SQL Server and Windows Authentication Mode:

6. Click OK in the Properties window, where you will be taken back into the Server Management Studio main screen. Right-click on the SQL Server instance name, and select Restart.