Configuring MSSQL Database

 

EventLog Analyzer lets users to configure and use MSSQL database.

 

Click the Database Console link to open the Database Console page. In the prompt window displayed, enter the query to be executed.

 

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

  1. From the installed MS SQLSERVER, copy the files bcp.exe and bcp.rll to <Eventlog Analyzer Home>\mysql\bin folder.
    note

    Note: If you are copying the above file from SQL Server 2005 installed server and the EventLog Analyzer is installed in other machine. Please copy the following dll to the <Eventlog Analyzer Home>\mysql\bin directory

    • %Program Files%\Microsoft SQL Server\80\COM\Microsoft.VC80.CRT.manifest
    • %Program Files%\Microsoft SQL Server\80\COM\msvcr80.dll
    • %WINDOWS%\system32\sqlncli.dll
  1. Invoke the <Eventlog Analyzer Home>\tools\changeDBServer.bat, to configure the MS SQLSERVER credentials like ServerName, Port, UserName and Password.
  2. Database Setup Wizard pops-up.
  3. In the wizard screen, select Server Type as SQL Server. Available SQL Server Instances are listed in a combo box. Enter the Host Name and Port of the SQL Server from the instances.
  4. Select the authentication type using the "Connect Using:" options.
  5. The options are:
    1. Windows Authentication

    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

    1. SQL Server Authentication

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

     

SQL Authentication

  1. Click 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. Clcik Save button to save the SQL Server configuration. Note that, it will take few minutes to configure the settings of the SQL Server database.
  3. Start the Eventlog Analyzer Server/Service to work with the MS SQLSERVER as the database.

From the installed MS SQLSERVER, copy the files bcp.exe and bcp.rll to <Eventlog Analyzer Home>\mysql\bin folder.

 


Copyright © 2008, AdventNet Inc. All Rights Reserved.