How to change the MSSQL backend database details used by EventLog Analyzer

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

  1. In the EventLog Analyzer server, open the command prompt as an administrator and set the location to <EventLog Analyzer             Home>\tools. 

  2. Execute the following command: ChangeDBServer.bat --config

  3. 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.

  1. ​Click Test Connections to test the connectivity, and click Configure DB to update the details.

  Tips  

  1. We recommend having a static IP address and fixed hostname to reduce downtime when updating the records.

  2. It is recommended to plan downtime to update Database user credential by considering the downtime for EventLog Analyzer.

 


      New to M365 Manager Plus?
      New to M365 Manager Plus?
        New to RecoveryManager Plus?
        New to RecoveryManager Plus?
          New to Exchange Reporter Plus?
          New to Exchange Reporter Plus?
            New to SharePoint Manager Plus?
            New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                    • 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 ...

                      Related Products