Cannot connect to the database after installing SMS Client

The SMS Client software uses a Microsoft SQL Compact Edition database to store customer and SMS history data. If the Microsoft SQL Server Compact Edition Runtime is not installed the SMS Client software cannot access the database.

Resolution
Check that the correction version of Microsoft SQL Server Compact Edition Runtime is installed.

    SMSClient 2x requires Microsoft SQL Server Compact Edition Runtime 3.5 SP1
    SMSClient 3x requires Microsoft SQL Server Compact Edition Runtime 3.5 SP2

The versions of Microsoft SQL Server Compact Edition Runtime 3.5 cannot be mixed. Use the same version for all installations of SMSClient.

Download the Microsoft SQL Server Compact Edition Runtime from here and install the package.
The SMS Client software should now be able to connect to the database.

If you are using Windows Vista/Windows 7/Windows 8/Windows 8.1
Windows UAC (user access control) prevents software from updating configuration settings if the user is not running the software under elevated privilege. The first time after installing or upgrading SMSClient you may receive a message that SMSClient could not connect to the database.

Resolution
Right click on the SMSClient icon and select ‘Run as administrator’ from the popup menu (see below). This will allow SMSClient to update its configuration settings. You should only be required to do this once. Under normal conditions the elevated security is not required.

faq-0001

.