Exchange Reporter Plus also supports MS SQL database. To start using Microsoft SQL database for your Exchange Reporter Plus Server repository, follow the steps below.
Open the SQL Server Configuration Manager.
Go to SQL Server Services → SQL Server Browser.
Make sure that the SQL Server Browser is running. (Note: The SQL Server Browser runs as a Windows service and provides information on SQL Server instances installed on the machine.)
Go to SQL Server Network Configuration → Protocols for <Instance_Name>.
Right click on the TCP/IP protocol and select Enable.
Restart the SQL Server Service for the change in setting to take effect.
Note that MS SQL does not come bundled with the installation of the product. You can either use the existing MS SQL server at your end as the default database server or download it afresh from the Microsoft website.
Prerequisites to communicate with MS SQL server
To use MS SQL installed in a remote machine, you would have to install the corresponding SQL native client and command line utilities in the Exchange Reporter Plus machine as per the SQL version and CPU type of the machine.
Copy the following files from the MSSQL Server installation folder to the Exchange Reporter Plus\bin folder.
bcp.exe- <MS SQL Installation Dir>\Tools\Binn\bcp.exe
bcp.rll- <MS SQL Installation Dir>\Tools\Binn\Resources\1033\bcp.rll
The TCP and UDP Ports need to be opened if firewall is enabled in SQL Server machine. The UDP Port is normally 1434.
Steps to change the Exchange Reporter Plus database to MS SQL
Shut down Exchange Reporter Plus before performing the below steps.
Go to Exchange Reporter Plus Home → \bin → Enter ChangeDB.bat in command prompt.
The Database Setup wizard pops up. Enter the required details to configure the database settings.
In Server Type, choose MS SQL Server from the drop down menu.
Enter the Host Name and select an instance from the list of available instances.
Enter a desired database name.
Choose if you want to migrate data or not from the Migrate Data option.
Select the required authentication type. You can choose either Windows Authentication or SQL Authentication.
If you have selected SQL Authentication, provide your username and password.
Click Test to check if a connection can be established with the provided credentials.
Click Save to save and complete SQL Server configuration.