HAVE QUESTIONS? CALL US TOLL FREE 866.425.0800 OR DIRECT AT 214.239.1985

KNOWLEDGE BASE

   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
Related articles
Was this information helpful?
 
Back to Search Results
FREE TRIAL

HAVE QUESTIONS? CALL US TOLL FREE 866.425.0800 OR DIRECT AT 214.239.1985