HOWTO: SQL Express is installed on my server but how can I configure WorkgroupShare to use this instead of MS JET?
SYMPTOMS
This article assumes that SQL Express is already installed and successfully running on your server. If it isn't and you would like to install it before proceeding with the instructions in this KB article, please see
this link.
MORE INFORMATION
You are in the process of installing WorkgroupShare on your server and have since discovered that it can be configured to use an SQL Express database. However, during installation, only two options appear:
JET database
SQL server
How then, can you use WorkgroupShare with SQL Express?
Since 2005 Microsoft have shipped 'express' versions of their mainstream enterprise database management system - SQL Server. These lightweight variants have limitations but nothing that would significantly impact performance making it a much more efficient and reliable and therefore the favoured database option for use with WorkgroupShare.
If you do not have SQL Express installed and wish to use Microsoft JET for the forseeable future, an upgrade path to SQL Express is still possible and is described here.
DETAILS
When you are prompted for which database WorkgroupShare will use, choose the second radio button "SQL Server". You will then be asked to specify your database instance. Usually for SQL Express installations this would default to SQLEXPRESS so either type the computer name or IP address of your server followed immediately with \SQLEXPRESS. For instance, if you computer is called MAIL, you would enter MAIL\SQLEXPRESS into the server combo box. Click next. If SQL is installed correctly and is currently accessible, you should not be prompted for server credentials as the current user credentials should be used first and this would normall succeed. If you are prompted for credentials then please double-check the server-name, the SQL instance and that SQL Server Express is running. If you have to change these details you will likely need to restart setup for the changes to be effected.
APPLIES TO
- All versions