Office Timesheets configuration with SQL Server Express
SQL Server Express is installed with different default configuration then SQL Server Standard Editions or higher. If you wish to install Office Timesheets on (machine A) and use SQL Express that is on (machine B) you'll need to do the following when using SQL Express.
1. You must enable remote connections for each instance of SQL Server Express that you want to connect to from a remote computer.
2. Create specific exceptions in your firewall settings for SQL Server Express.
3. Enable the SQL Server Browser service (verify with the articles in the links below to see if this applies to your setup).
****** See the following 2 articles that reference how to perform the above steps ******
Additionally, during the installation setup the "Database Server Name" field must be created with the following format:
Note: Replace "myserver" from above with the name of the machine that houses the SQL Server Express application. Replace "IP address" from above with the actual IP address of the machine that houses the SQL Server Express application.