Post database change steps for Collector Server
When the Collector Server is installed, it is registered with Admin Server as Collector Server with MySQL.
If the database of the Collector Server is changed from MySQL to MSSQL, it has to be re-registerd with Admin Server as Collector Server with MSSQL.
After changing the database, when the Collector Server is started as application, it will prompt the user to re-register with the Admin Server.
After changing the database, when the Collector Server is started as service, there will not be any prompt to re-register. User has to ensure that the Collector Server is re-registered with the Admin Server.
Firewall Analyzer lets users to migrate the existing Firewall Analyzer data available in MySQL database to MSSQL database.
This procedure is applicable only if you are already using the Firewall Analyzer with MySQL and you want to change the database to MSSQL.
If you want to configure the MSSQL for fresh installation of Firewall Analyzer server, please refer the Configuring MSSQL Database page and follow the procedure given there.
The steps to migrate and run the Firewall 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 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)
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 Firewall 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.
Executing the restoreDatabase.bat will delete the existing data, if any.
You can also change the backup directory. Execute the batch file to backup by passing the absolute path of the directory as argument in the command prompt. Example command execution as follows:
<Firewall Analyzer Home>tools:>backUpDatabase.bat D:Mysql