Knowledge Base FAQ Item #7750110

Q7750110: Can I migrate the statistical database to MS SQL Server Express Edition? If yes, how can this be done?

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.

(viewed: 1657)