SQL Database Security & Best Practices

1. Security and Workflows

SQL Server Application workflow

BrowseReporter tracked data is temporarily stored on the local machine where the cwClient is installed. The local client has a database named WCRB.CWK, which is an encrypted Microsoft Access database. It holds the data before it sends the data to the CurrentWare Server.

Once the server receives the data and stores it on the server’s SQL database, it will delete the local data from the WCRB.CWK database.

CurrentWare Client to CurrentWare Server Communications

The Client talks to the Server using socket technology on several CurrentWare ports ranging from 8990 to 8998. You can see each one here: https://www.currentware.com/support/open-ports/

CurrentWare Server to SQL Database Communication

The CurrentWare Server will process updates of information to the SQL database by using the default SQL ports 1433 and 1434.

2. Best Practices for BrowseReporter Configuration:

–        Do you need to track the browsing bandwidth usage? If not needed, turning it off will reduce your storage needs.
This is done by going to Settings > BrowseReporter and unchecking “Enable Bandwidth Tracking”

–        You can set up an Auto Delete Schedule to automatically remove data after a specific time period. The knowledge base to set up that feature up is here: https://www.currentware.com/support/can-currentware-delete-older-data-automatically/ 

–        Set the CurrentWare Server to auto restart on specified time period (24hrs+). This will ensure your client connections are always stable and ensure the data is being uploaded efficiently.
This is done by going to Settings > Server Settings and enabling “Restart CurrentWare server every # of hours”

–        On your initial installation: remove other CurrentWare solutions from the Console. From the desktop console go to Help > Licensing > select the unused solutions and choose “Remove”. Repeat for each solution not needed.