When installing the offline database, the installation fails with a timeout. Looking into the RetailDatabaseUtility.log, it comes with these messages.
atabaseUtility, 4, 08/08/2012 07:24:48:833, An error occurred during provisioning. Removing all provisioning artifacts. Error Message: ‘Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.’
The database is a SQL 2008 Express Edition and the customer also installed the store database on the same machine. Due to multiple connection to the Express version, the DBUtility gets an timeout on the connection.
Since it makes no sense to install both store database and Offline database on the same machine. The recommendation is
Small stores with 1-2 POS
Install SQL Express 2008/R2 edition on all machines. If there is example 2 pos, let 1 run the store database and the other an offline database
If there is only 1 POS, only install the store database
Medium – large stores > 2 pos
SQL 2008/R2 standard edition as store database (clustering could be considered for large stores)
On all POS install SQL2008/R2 Express edition and then add the Offline database
Author: Kim Truelsen