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

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

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

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