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 for Microsoft SQL Server
From the Windows Start menu, choose Run, and then type the following command:
Navigate to the directory that contains the OSQL.EXE file.
For Microsoft SQL Server 2008, the default directory location for this file is C:\Program Files\Microsoft SQL Server\100\Tools\Binn
For Microsoft SQL Server 2005, the default directory location for this file is C:\Program Files\Microsoft SQL Server\90\Tools\Binn.
For Microsoft SQL Server 2000, the default directory location for this file is C:\Program Files\Microsoft SQL Server\80\Tools\Binn.
Log in as the system administrator user. Type the following command, and then at the Password prompt, type the system administrator password:
At the command prompt, type the following commands:
For Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (MSDE):
EXEC sp_addlogin 'account_name', 'password', database_name'
EXEC sp_grantdbaccess 'account_name'
EXEC sp_addrolemember 'db_datareader', 'account_name'
For Microsoft SQL Server 2005 and Microsoft SQL Server 2008:
EXEC sp_addlogin 'account_name', 'password', 'database_name'
CREATE USER 'account_name' FOR LOGIN 'account_name'