How to use Windows Authentication with database sensor collectors.
Previously Windows Authentication could not be used because previous versions of MS SQL Server JDBC drivers do not support it.
Windows Authentication is only supported with Microsoft SQL Server 2005 JDBC driver version 1.1 or newer.
To setup Windows Authentication with Symantec database sensor collectors:
In some situations you might need to copy the sqljdbc_auth.dll in the .\jre\lib folder where the SSIM Agent is installed.
You must setup the Event Agent with the users credentials because the Windows Authentication feature of the JDBC driver does not allow entering the Windows username/password explicitly. It instead searches the local computer credential cache for credentials that have already been provided at the computer or network logon.
If you want to create a user in your DB, please consult your DBA first. Example of script you can use to create and add the Windows user inside the DB permission for the read only user.
create login [Windows\sql_user] from windows
EXEC sp_addrolemember 'db_datareader', [Windows\sql_user];
grant select on sem_computer to [Windows\sql_user]
Example above is for SEP collector. Bascially you add the user to the DBreader group of the collector DB.