Configuring MS SQL

Exchange Reporter Plus comes bundled with PostgreSQL database. However, it also supports MS SQL as its backend database. To start using MS SQL database for your Exchange Reporter Plus Server repository, follow the steps below.

1. Open the SQL Server Configuration Manager.
2. Go to SQL Server Services → SQL Server Browser.
3. 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.)
4. Go to SQL Server Network Configuration → Protocols for <Instance_Name>.
5. Right click on the TCP/IP protocol, and select Enable.
6. Restart the SQL Server Service for the setting change to take effect.

Note: Since MS SQL isn't bundled with the product, you can either use the existing MS SQL Server at your end as the default database server or download it from the Microsoft website.

Prerequisites to communicate with MS SQL Server

To use MS SQL Server that is installed in a remote machine, you must install the corresponding SQL native client and command line utilities in the machine where Exchange Reporter Plus is running. Choose and install SQL native client and command line utilities depending on the SQL version and CPU type of the machine.

Upon completion of SQL native client and command line utilities installation, you need to copy the following files from the MS SQL Server installation folder to the Exchange Reporter Plus\bin folder to establish proper communication.

• bcp.exe- <MS SQL Installation Directory>\Tools\Binn\bcp.exe
• bcp.rll- <MS SQL Installation Directory>\Tools\Binn\Resources\1033\bcp.rll

The TCP and UDP ports need to be opened if a firewall is enabled in the SQL Server machine. The UDP Port is normally 1434.