Setting the SQL Server security mode to mixed authentication

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.