Did you enable TCP/IP for SQL Server ? Is the collector on the same machine as the SQL Server ?
If you don't see anything in the dropdown, that means the user doesn't have the correct permissions to read the tables on the database.
** The DB user must have Read Any Permissions to work properly
** The actual Needed Permissions are: VIEWANYDEFINITION "View ANY DEFINITION", INFORMATION SCHEMA.TABLE "INFORMATION SCHEMA.TABLE"( Gives the list of tables), SYS.COLUMS "SYS.COLUMS" (List of Fields)
No. Collector is not in the same machine but Connectivity is there.
I tried this, but still not able to view Database
Are you saying the collector is not installed on the machine that DB is on?
- SQL DB is on machine A
- SIEM Collector is installed on Machine B