How to Configure SQL Server 2005/2008 to Accept SQL Authentication?

There are 2 methods of authentication to SQL Server 2005/2008. These are: Windows authentication (default) SQL Server authentication (or mixed authentication). In this article I'm going to show you the 2nd method (SQL Server authentication): In order to use SQL Server authentication you must first configure your server using the steps below.

  1. Right-click on the server node and select 'Properties'.
  2. Select 'Security' from the left menu under 'Select a page'. Server Properties - Security
  3. Under 'Server Authentication', select the 'SQL Server and Windows Authentication mode option'.
  4. Click 'OK' to close the dialog.
  5. Right click on the server node and choose 'Restart' for the changes to take affect.

Enable SQL Server login

1. In the server node expand 'Security' and 'Logins'.

2. Right-click on a login name and select 'Properties'.

3. Enter a password and confirm the password for the login.

4. Select 'Status' from the left menu under 'Select a page'. 5. Set the 'Login' option to 'Enabled'.

6. Click 'OK' to close the dialog. That's it -  you're done!

Categories

Archive