Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Act 2006 for Workgroups and SQL

Posted on 2006-05-30
Medium Priority
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
  • 2

Accepted Solution

SStroz earned 2000 total points
ID: 16795669

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 www.act.com that has a lot of how-to articles.

I hope this helps.  Good luck.

Steve Stroz

Expert Comment

ID: 16795701

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses
Course of the Month10 days, 16 hours left to enroll

572 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