How to change the MSSQL backend database details used by EventLog Analyzer
Objective
This article provides step-by-step instructions for updating the Microsoft SQL Server (MSSQL) backend database details used by EventLog Analyzer, such as:
IP address of the database server.
Port number.
Database password.
Updating your MSSQL backend database details is typically required if the database server has been moved, reconfigured, or the credentials have changed.
Prerequisites
- Access to the EventLog Analyzer server as an administrator to execute bat files.
- Updated user credentials.
- EventLog Analyzer version 12420 and above.
Steps to follow
- In the EventLog Analyzer server, open the command prompt as an administrator and set the location to <EventLog Analyzer Home>\tools.
Execute the following command: ChangeDBServer.bat --config
Update the details in the prompt.
Note: The Database Name and Username field values must match with the existing database configuration. You can verify this by checking the <EventLog Analyzer Home>\conf\database-params.conf file.
- Click Test Connections to test the connectivity, and click Configure DB to update the details.
Tips
We recommend having a static IP address and fixed hostname to reduce downtime when updating the records.
It is recommended to plan downtime to update Database user credential by considering the downtime for EventLog Analyzer.
New to ADSelfService Plus?
Related Articles
Unable to start EventLog Analyzer
Issue description This issue occurs when the EventLog Analyzer service fails to start, or when users are unable to access the web client through the browser (typically on ports 8400 or 8445). Users may experience one or more of the following ...How time conversion works in EventLog Analyzer
Objective This article explains how time conversion is handled in EventLog Analyzer while accessing log data when the EventLog Analyzer server and endpoint devices operate in different time zones. It also provides guidance on how to identify and ...How to back up EventLog Analyzer
Objective This article will help you perform a manual folder backup, which can be used for restoring the ManageEngine EventLog Analyzer installation with all existing configurations. Prerequisites Access to the EventLog Analyzer server with full ...How to stop EventLog Analyzer | Windows OS
Objective This article offers step by step instructions for a clean shutdown of EventLog Analyzer application in Windows OS without disrupting the application. Prerequisites Need access to the EventLog Analyzer server installation folder, as well as ...Troubleshooting guide: EventLog Analyzer UI is unresponsive
Overview This document outlines the common causes and recommended steps to resolve the issue when the EventLog Analyzer UI becomes unresponsive. Possible causes Insufficient system resources High CPU or memory usage on the server. Low disk space in ...