EventLog Analyzer lets users to configure and use MSSQL database.
The procedure to configure the MSSQL is applicable only for fresh installation of EventLog Analyzer server.
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.
The steps to configure and run the Eventlog Analyzer server with SQLSERVER as the database is given below:
Note: If you are copying the above file from SQL Server (Version 2005 & above) installed server and the EventLog Analyzer is installed in other machine, please install the following SQL Native Client in the EventLog Analyzer machine as per the SQL vesion and CPU type of EventLog Analyzer machine.
MSSQL 2005 (32 bit)
MSSQL 2005 (64 bit)
MSSQL 2008 (32 bit)
MSSQL 2008 (64 bit)
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.
For SQL Server Authentication, enter the User Name and Password.
Note: Details about user roles: Refer the documents in the following links: 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 additional resources: http://www.mssqlcity.com/Articles/Adm/SQL70Roles.htm
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 SQL Server and have completes control over all database functions.
The members of db_owner database role can perform any activity in the database.
From the installed MS SQLSERVER, copy the files bcp.exe and bcp.rll to <Eventlog Analyzer Home>\mysql\bin folder.