ActiveXperts Knowledge Base Article 7750110
Yes, MS SQL Express Edition is supported. For a list of suppported SQL Express versions, see FAQ #7750115
Migration to MS SQL Server Express Edition can be done in the same way as migrating to MS SQL Server, with only one difference: you MUST specify the instance ID of the SQL Server Express Edition database in the 'Host' field.
For example, if the name of the database server is named 'DbServer01', and the instance id of the database is named 'SQLExpress', then specify 'DbServer01\SQLExpress'.
The performance of MS SQL Server is faster than MS SQL Server Express. See also FAQ #7740120.
For supported SQL Express database drivers, see FAQ #7750117.
Microsoft SQL Express Setup recommendations
ActiveXperts recommends using SQL Server authentication (default account 'sa') instead of Windows authentication. The best way to achieve this is to select a "Custom Installation" during Microsoft SQL Express setup.
When prompted for authentication mode, select Mixed Mode (SQL Server Authentication and Windows Authentication).
Make sure to enable the 'SQL Server Browser' service. This service is disabled by default, but can be enabled in the Custom Setup.
Also, make sure that Windows Firewall allows connections from remote servers.
Contact Support
If you cannot find an answer to your question(s) in our Knowledge Base, or if you need additional information or assistance, please contact our Customer Support using the Contact Support form:
Contact Support »