Collectors that use a database sensor require that you create a read-only database user account so that the collector can query for events.
See Installing collectors that use a database sensor.
To create a read-only database user account for Microsoft SQL Server 2000
In the SQL Server Enterprise Manager window, in the left pane, expand Console Root > Microsoft SQL Servers > SQL Server Group.
Click the appropriate server host name or click local, and then click (Windows NT) > Security.
In the SQL Server Login Properties - New Login dialog box, on the General tab, in the Name box, type the name of the read-only logon account.
In the SQL Server Authentication Password box, type a password.
Under Permit in Database Role, click db_datareader.
This role gives the user read-only data access to the database.
The role of public is always selected and cannot be cleared.
Confirm the password for the user that you created, and then click OK.