Using Mixed Mode

If you have some users who are authenticated using their Windows login and some who are using an SQL user account, the SQL Server must be run in Mixed Mode.

1. Open Microsoft SQL Server Management Studio.
2. Click the server and then click Properties.
3. Click Security. Under Server authentication, make sure that the SQL Server and Windows Authentication mode is selected.

You can also change this setting in DBServer Manager:

1. Connect to the database as an administrator.
2. Click Manage users.
3. Click Server authentication.

If you have some users who are authenticated using their Windows login and some who are using an SQL user account, the SQL Server must be run in Mixed Mode.