Fast Tip Friday: Less SQL, More Sage ACT 2011! #SageACT
bybwhalen_sage09-03-201008:53 AM - edited 09-08-201009:42 AM
With Sage ACT! 2011, you have a new option to take advantage of during installation! If you plan to have two or more Sage ACT! users, all connected to the same database, and the database is on a separate server, you do not need to install Microsoft SQL Server Express on every computer. This is a welcome change for system administrators that are not comfortable with an installation of Microsoft SQL Server Express on every Sage ACT! workstation, and for those users seeking to maximize system resources on their machine.
However, be aware that SQL Server Express is needed to create or synchronize a database. If you opt to skip the SQL Server Express install and your organization needs to synchronize or cut remote databases, make sure that SQL Server Express is installed on the computer that will host the database.
To install the Sage ACT! program files without Microsoft SQL Server Express:
During installation, you will be presented with two install options:
– Typical install which installs Sage ACT! 2011 and Microsoft SQL Server Express files to default locations, and uses common settings for other installation options.
– Custom installation which enables you to choose where to install Sage ACT! 2011 and Microsoft SQL Server Express files, whether or not Microsoft SQL Server Express files are installed, as well as customize other installation options such as whether or not a shortcut is placed on the desktop.
To install Sage ACT! Program Files without Microsoft SQL Express files, select Custom and click Next
On the Destination Folder screen:
- (OPTIONAL) Under the “Select the folder where Sage ACT! will be installed” section, click the Browse… button and select a new destination folder.
- Under the “Select the folder where SQL Server Express will be installed” section:
clear the Install SQL Server Express check box An important notification will appear:
Important Note: Several Sage ACT! 2011 features do not function
when you install without SQL Server Express such as: