How Does eG Enterprise Monitor the Microsoft SQL Report Server?
eG Enterprise can monitor the Microsoft SQL report server in an agent-based or in an agentless manner. However, the agent-based approach is recommended. An eG agent deployed on the report server runs queries on the report server database to provide deep insights into the performance of the report server.
To enable the eG agent to run queries and pull the desired metrics, the following pre-requisites should be fulfilled:
- The report server can be installed with the Microsoft SQL server – i.e., on the same host as that of the Microsoft SQL server - or on a different host. If the report server is co-located with the Microsoft SQL server, then make sure that you manage the Microsoft SQL Report Server component in eG Enterprise using the IP/host name of that Microsoft SQL server. On the other hand, if the report server is installed on a different host, then make sure you manage the Microsoft SQL Report Server component in eG using the IP/host name of that host.
- When managing the Microsoft SQL Report Server component using eG, the Port number you specify should be the port at which the report server listens. This is port 80 by default. You can override this default value, if there is a change in the report port. Before making the change, figure out the exact port at which SSRS listens. For this, follow the procedure detailed in Determining the Port Number of Microsoft SQL Report Server.
- Configure the eG agent to connect to the SSRS database. To know how this is to be performed, refer to Configuring the eG Agent to Connect to the Report Server Database.
- Configure the eG agent with the credentials of a user with SELECT privileges to the ExecutionLog, Catalog, runningjobs, and users tables of the Microsoft SQL report server database. For this purpose, you can create a special user on the Microsoft SQL server, grant the required monitoring privileges to that user, and configure the eG agent with the credentials of that user. To know how to create such a user, refer to Configuring the eG Agent with the Permissions Required for Running Queries.