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:
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 to reset the local technician password in EventLog Analyzer
Objective This article provides step-by-step instructions on how to reset the local technician's password. Prerequisites Ensure you have administrator access to the EventLog Analyzer console. Steps to follow Password can be reset using two ways: ...
Introduction to EventLog Analyzer
What is log management? An enterprise network consists of different entities—perimeter devices, workstations, servers, applications, and more. Each entity records every activity that unfolds within it in the form of logs. These logs hold information ...
How to backup and restore an EventLog Analyzer instance?
Backup Process: IMPORTANT: A backup of EventLog Analyzer should not be taken when the instance is running. Stop the ManageEngine EventLog Analyzer service. Open a command prompt with admin privileges. Navigate to <dir>:\ManageEngine\EventLog ...
How to perform removable disk auditing in EventLog Analyzer
Objective This article explains how to enable removable disk auditing for EventLog Analyzer. Prerequisites Windows 8 or Windows Server 2012 and above. Permission to enable the audit policy. Access to add a registry entry. To enable this: The winreg ...