Configure MSSQL database


How to find build number?

In the EventLog Analyzer web client, click Help > About link in the top pane. You will find the build number mentioned below the build version. This is the build number of the currently installed EventLog Analyzer.

 

Procedure for EventLog Analyzer version 8.0 (Build 8010) onwards

EventLog Analyzer allows users to configure and use MSSQL database.

The procedure to configure the MSSQL is applicable only for fresh installation of EventLog Analyzer server.

The steps to configure and run the Eventlog Analyzer server with SQLSERVER as the database is given below:

  1. From the installed MSSQL SERVER, copy the files bcp.exe and bcp.rll to <Eventlog Analyzer Home>bin folder.
Note:

If you are copying the above file from SQL (version 2005 & above) installed server and Event Log Analyzer is installed in other machine, please install the following SQL Native Client as per the SQL version (for MSSQL version below 2016) / ODBC driver 13.1 (for MSSQL version 2016) in the Event Log Analyzer machine and CPU type of Event Log Analyzer machine.

MSSQL 2005 (32 and 64 bit)
https://www.microsoft.com/en-in/download/details.aspx?id=17943

MSSQL 2008 (32 bit)
http://go.microsoft.com/fwlink/?LinkId=123717&clcid=0x409

MSSQL 2008 (64 bit)
http://go.microsoft.com/fwlink/?LinkId=123718&clcid=0x409

MSSQL 2014
https://www.microsoft.com/en-in/download/details.aspx?id=36434

MSSQL 2016

https://www.microsoft.com/en-in/download/details.aspx?id=53339

 

  1. Invoke the <Eventlog Analyzer Home>tools/changeDBServer.bat, to configure the MSSQL SERVER credentials like ServerName, Port, UserName and Password.

  2. Database Setup Wizard pops-up.

  3. In the wizard screen, choose the Server Type as SQL Server. Enter the Host Name and Port of the SQL Server. Select the instance from the available SQL Server Instances.

    Tips:
    1. Ensure that the server browser service is enabled as it provides information about the SQL Server instances.
    2. Ensure that TCP/IP are enabled under protocols in the SQL Sever Configuration Manager.

  4. Select the authentication type using the "Connect Using:" options.

  5. The options are:

 

For Windows Authentication, enter the Domain Name, User Name and Password. Ensure that both EventLog Analyzer server and SQL Server are in the same domain and logged in with the same Domain Administrator account.

 

Windows Authentication

 

For SQL Server Authentication, enter the User Name and Password.

 

SQL Authentication

 

‚ÄčNote: 

The product functions even if the table compression is enabled.

Details about user roles:

For Server Level Roles: http://msdn.microsoft.com/en-us/library/ms188659.aspx 

For Database Level Roles: http://msdn.microsoft.com/en-us/library/ms189121.aspx 

For Windows authentication or SQL server authentication, Server Role of the user should be 'sysadmin' and Database Role of the user should be 'db_owner'.
The members of sysadmin server role can perform any activity in the SQL Server and will have complete control over all database functions.
The members of db_owner database role can perform any activity in the database. 

 

  1. Click the Test button to check whether the credentials are correct. If the test fails, the credentials may be wrong. Recheck and enter the correct credentials.

  2. Click the Save button to save the SQL Server configuration. Note that it will take a few minutes to configure the settings of the SQL Server database.

  3. Start the Eventlog Analyzer Server/Service to work with the MSSQL SERVER as the database.

From the installed MSSQL SERVER, copy the files bcp.exe and bcp.rll to <Eventlog Analyzer Home>bin folder.

 

Procedure for EventLog Analyzer version 8.0 (Build 8000) or earlier

The procedure to configure the MSSQL is applicable only for fresh installation of EventLog Analyzer server.

From the installed MSSQL SERVER, copy the files bcp.exe and bcp.rll to <EventLog Analyzer Home>mysqlbin folder and follow the procedure given above.

If you are already using the EventLog Analyzer with MySQL and you want to change the database to MSSQL, please refer the Migrating EventLog Analyzer Data from MySQL to MSSQL Database page and follow the procedure given there.

 

Get download link