Setting the SQL Server security mode to mixed authentication

Article Id: 179870
Status: Published
Updated On: 18-01-2010 04:07
Legacy Id: HOWTO30414
Products:
Security Information Manager
Issue/Introduction:

 

Resolution:

Setting the SQL Server security mode to mixed authentication

See Installing collectors that use a database sensor.

To set the SQL Server security mode to mixed authentication for collectors that read events from Microsoft SQL Server

  1. From the Start menu, click Programs > Microsoft SQL Server > SQL Enterprise Manager.

    With SQL Server 2000, you choose SQL Enterprise Manager.

    With SQL Server 2005, you choose Microsoft SQL Server Management Studio.

    With SQL Server 2008, you choose SQL Server Management Studio.

  2. Click the appropriate server.

  3. From the Tools menu, click SQL Server Configuration Properties, and then click Security.

  4. Under Authentication, click SQL Server and Windows.

  5. Click OK, and then click Close.