Act 2006 for Workgroups and SQL


I have a client who purchased two licenses of Act 2006 for Workgroups and wants to host the database on an existing SQL server which is on their main file server.  The 2 licenses were installed on two client PC's and then they took one of the licensed CD's and went to the server and did an install.  

I have no idea how they are supposed to get their Act! 2006 database or start a new, on the SQL server.  Sage is of little help.  So my questions are:

How do I start the Act database on SQL?

Do I need a 3rd license for the server, despite no on ever sitting there at it to use Act?

Thanks for any help!

Who is Participating?

It sounds like the install procedure was correct.  I am hoping they used a different license on each workstation.  These licenses are later "absorbed" into the databases to determine how many active users can access the database at the same time.  (If they used the same serial number on both workstations, they can remove one and enter the other serial number by clicking Help, Register ACT!..., at the following dialog click "Remove Serial Number".  This will give them the opportunity to re-register using the other serial number).

Because you will not use the server as a "workstation" but rather to host the database you do NOT need another copy/serial number for the file server.  This is specified in section 1.C of the license agreement.  {this Agreement permits you to:} (c) use the Software via a local area network, provided that you have purchased a licensed copy of the Software for each named user who can access the Software over that network.

It is a requirement for ACT! 2006 Premium for Workgroups to be installed on the file server for it to function properly so again - this was the correct procedure.

ACT! 2006 Premium for Workgroups installs a proprietary instance of MS SQL Server 2003 (with SP3).  This can co-exist with other full versions of MS SQL.  I assume there were no install problems on the file server.  You can verify this by clicking Start, Run, services.msc.  Look for the MSSQL$ACT7 service.  You should see that the "Status" = Started and "Startup Type" = Automatic.

To create a new ACT! database open the ACT! 2006 Premium for Workgroups program on the file server.  You will probably be prompted to complete the "Quick Start Wizard".  Run through the wizard, and also register the software using one of the above serial numbers.  You do not have to create a new database during the wizard - select "skip".

Then create a shared network folder (ACTDATA) with a "Database" subfolder.  Make sure to share it with full rights for all of the ACT! users.  After you create the folder, open ACT! and click File, New Database.  1.  Name the database (use a SQL friendly name) 2. Browse to the "ACTDATA\Database" folder you created 3. Make sure to click the "Share this database with other users checkbox.  4.  Enter a user name (It should be one of the workstation users above) - password is optional.  5.  Click OK.

This should create the database.  You may want to log into the database and add the other user name.  To do this click Tools, Manage Users.  Click "Create New User" and follow the instructions.

Then from each user's workstation - Open ACT!, Click File, Open and navigate to the *.pad file located under the ACTDATA\Database folder.  You will be prompted for the user name and password.  Enter the appropriate info and click OK to start having ACT! fun.

Also note that because ACT! is using a proprietary SQL instance and you won't have access to the SA password (until you buy it) you will not be able to access the ACT! database using SQL Enterprise Manager.  There is a behind the scenes tool called ACT8DIAG.EXE that lets you perform a variety of maintenance procedures, etc.  You can access it by clicking Start, Run, type:  ACT8DIAG   and click OK.  Also note that although technical support can be a little trying they have a pretty good knowledgebase located at that has a lot of how-to articles.

I hope this helps.  Good luck.

Steve Stroz

In re-reading your question I noticed you said "ACT 2006 for Workgroups".  I assumed you meant:  ACT! by Sage Premium for Workgroups 2006.  There is a "standard" version called ACT! by Sage 2006.

The standard version uses MSDE instead of the full-blown instance of MS SQL Server.  The standard version (MSDE) has a 10 user limit, a 2GB storage limit, and a few functionality restrictions.

The rest of my comments above are interchangeable.

Steve Stroz
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.