Office Timesheets

SELECT CATEGORY

Home

FAQ

Help

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 ******

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-access-server-configuration-option?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver15

Additionally, during the installation setup the "Database Server Name" field must be created with the following format:

localhost\sqlexpress

or

myserver\sqlexpress

or

IP address\sqlexpress

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.

ID
40

Category
Office Timesheets On Premise

Date Created
7/2/2007 2:29:55 PM

Date Updated
3/11/2020 1:05:08 PM

Was this information helpful?

Back to Search Results

OTHER LOOKOUT PRODUCTS

OFFICE TIMESHEET SOLUTIONS

IMPORTANT LINKS