User guide

ManageEngine Firewall Analyzer :: User Guide
274
Zoho Corp.
Configuring MSSQL Database
Firewall Analyzer lets users to configure and use MSSQL database.
The procedure to configure the MSSQL is applicable only for fresh installation of
Firewall Analyzer server.
If you are already using the Firewall Analyzer with MySQL and you want to change the
database to MSSQL, please refer the Migrating Firewall Analyzer Data from MySQL
to MSSQL Database page and follow the procedure given there.
The steps to configure and run the Firewall 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
<Firewall Analyzer Home>\mysql\bin folder.
Note: If you are copying the above file from SQL Server (Version 2005 &
above) installed server and the Firewall Analyzer is installed in other
machine, please install the following SQL Native Client in the Firewall
Analyzer machine as per the SQL vesion and CPU type of Firewall Analyzer
machine.
MSSQL 2005 (32 bit)
http://download.microsoft.com/download/4/4/d/44dbde61-b385-4fc2-
a67d-48053b8f9fad/sqlncli.msi
MSSQL 2005 (64 bit)
http://download.microsoft.com/download/4/4/d/44dbde61-b385-4fc2-
a67d-48053b8f9fad/sqlncli_x64.msi
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
2. Invoke the <Firewall Analyzer Home>\tools\changeDBServer.bat, to configure
the MS SQLSERVER credentials like ServerName, Port, UserName and Password.