This article discusses the user permission requirements that are necessary in order to successfully use SysKit Insights.
User Permissions Requirements
To run SysKit Insights and to retrieve all the data (event logs and performance counters) you want to document, SysKit Insights service account needs to have proper privileges. Here is the list of required privileges:
- Local administrator on all the machines you want to monitor. Both SharePoint and SQL server.
- We are using Remote WMI to access performance metrics on SQL servers. As per this Microsoft article local administrator privileges on a remote server are required to successfully access the performance data using Remote WMI approach.
- SysKit Insights requires local administrator privileges to access logs (ULS, Windows Event Log, SQL Log) on remote machines as well. It is not possible to access those locations remotely without local administrators privileges (Windows constraint).
- Minimum of db_datareader on a SharePoint's Config database.
- On a SQL server - public server role.
- The account running the SysKit Insights Configuration Wizard must have dbcreator role on the SQL Server where the SysKit Insights database will be created.
SysKit Insights relies on Active Directory to reach the names/addresses of the computer. So, the Service Account needs to have permission to read from AD.
After that it uses WMI to collect all the data.
If you have a firewall between the machine hosting the application and the servers that are being monitored, you will need the following info.
The firewall inbound rules on Windows Server 2008, 2008 R2, 2012, 2012 R2, 2016 and 2019 are (this is inside the windows firewall):
- File and printer sharing (NB-Session-In)
- Network Discovery (NB-Name-In)
- Network Discovery (NB-Datagram-In)
- COM+ Remote Administration (DCOM-In)
In case you have the third party firewall the ports are:
- RPC TCP 135
- NetBIOS Datagram Service UDP 138
- NetBIOS Name Resolution UDP 137
- NetBIOS Session Service TCP 139
Only for performance counters:
- TCP Any, the special rule in Windows Firewall [performance logs and alerts (DCOM-IN)]
- RPC TCP 135 [performance logs and alerts (TCP-IN)]
Only for Page Performance:
- SysKit Insights service account must have at least Read permisison level on the page that SysKit Insights is monitoring.