Configuring Microsoft SQL Server Authentication

In order to use Microsoft SQL Server Authentication, your Microsoft SQL Server must be configured to allow this option.  This is configured from Microsoft SQL Server Enterprise Manager.

To enable Microsoft SQL Server Authentication:

Step 1:  Start Microsoft SQL Server Enterprise Manager.

Step 2:  Locate the Microsoft SQL Server you wish to configure.  Right-click the server and select Properties to open the SQL Server Properties dialog.

Step 3:  In the SQL Server Properties dialog, select Security.

Step 5:  Select “Authentication: SQL Server and Windows” or “Authentication: Windows” and close the dialog.  This configures your Microsoft SQL Server.

You should now be able to connect to Microsoft SQL Server using Microsoft SQL Server Authentication.  When selecting database tables, you must know the specific name and password of the Microsoft SQL Server login that has the appropriate permissions to read and write to the databases you use.

See Also

Configuring Database Authentication for Microsoft SQL Server Applications

Configuring Windows Authentication

Configuring Microsoft SQL Server Authentication