| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
About Collectors
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
...
Pre-requisites
...
Access to K landing directory
Collector server minimum requirements
| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
...
SQL Server
...
Requirements
Setting up SQL Server for metadata extraction is a 2 step process.
...
| Code Block |
|---|
CREATE LOGIN kadauser WITH password='PASSWORD'; CREATE USER kadauser FROM LOGIN kadauser; |
| Note |
|---|
Apply per database in scope for metadata collection. |
| Code Block |
|---|
CREATE USER kadauser FROM LOGIN kadauser;
GRANT VIEW DEFINITION TO kadauser;
GRANT VIEW DATABASE STATE to kadauser;
GRANT CONTROL to kadauser; -- required for extended events sys.fn_xe_file_target_read_file |
The following table should also be available to SELECT by the user created in each database
...