Setting SQL to operate in Mixed mode

SQL Server must operate in Mixed mode—that is, using either Windows Authentication or SQL Authentication. To confirm or change this setting, follow these steps:

1. Open the SQL Enterprise Manager by choosing StartOAll ProgramsO Microsoft SQL ServerOEnterprise Manager.

2. In the left pane of the window, click the plus signs to open the tree until you find your SQL server, and then select it (see Figure 18-2).

Figure 18-2: Select your SQL server.

3. Choose ActionOProperties to display the SQL Server Properties dialog box (see Figure 18-3).

Figure 18-3: The SQL Server Properties dialog box.

4. Click the Security tab and, if necessary, select the SQL Server and Windows Authentication option.

5. When prompted to stop and restart the SQL Server service, click Yes, and wait while SQL stops and restarts.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment