Setting Up the SQL Server in Mixed Mode

Before the Backup Exec service can monitor the results of the discovered jobs performed by Microsoft SQL Server database, you must set up SQL Server in mixed mode.

Review the changes below, approved, and implemented by a Microsoft certified professional. For more information on switching SQL Server to Mixed Mode, contact Microsoft Corporation.

  1. Click Start > All Programs > Microsoft SQL Server > Enterprise Manager.
  2. Navigate to the appropriate SQL Server Group.
  3. In the contents pane, right-click the appropriate SQL server.
  4. Click Properties and click the Security tab.
  5. Under the Security heading, locate the Authentication section and select SQL Server and Windows.
  6. Click OK.