Act 2006 for Workgroups and SQL

Posted on 2006-05-30
Last Modified: 2013-11-24

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!

Question by:hydrazi
    LVL 7

    Accepted Solution


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

    Expert Comment


    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Supply Chain Event Management Supply chain visibility is the ability of a company to track its products and business processes in supply chain towards building operational excellence. The goal of supply chain visibility is to improve and strength…
    Hello All, In previous article we used Hortonworks sandbox to work with Hadoop. Now, lets think to create own single node Hadoop on Linux. Here we Install and Configure Apache Hadoop on UI based Oracle Linux. I assume, you have VMware installe…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now