How to manually create the Microsoft SQL Server 2005 (Standard Edition) ACT7 Instance

Summary

When ACT! by Sage Premium for Workgroups is installed, Microsoft SQL Server 2005 Standard Edition is automatically installed
and an ACT7 Instance created. If Microsoft SQL Server 2005 Standard Edition is already installed on the PC, you need to create a
SQL Instance for ACT! by Sage Premium for Workgroups.

This article explains how to create a SQL Instance for ACT! by Sage Premium for Workgroups and contains the following sections:

Note: You must complete the steps in the order presented. ACT! by Sage Premium for Workgroups must not be installed before  creating the ACT7 Instance. All future updates to the SQL Server are applied with updates to ACT! by Sage.

Answer

Sage (UK) Limited provide this information as a guide, we do not provide support for Microsoft Products. You must have a valid license from Microsoft for a copy of Microsoft SQL Server 2005 that permits multiple instances, for example, the Processor Licensing Model. For further information about this, please refer to www.microsoft.com.

These are the basic steps that explain how to manually create the Microsoft SQL Server instance. They include:

  • To create a Microsoft SQL Server 2005 instance for ACT! by Sage
  • To ensure the SQL Server Browse service is running
  • To update Microsoft SQL Server 2005 to Service Pack 1

Note: Quick steps provide the minimum amount of information you need. For further information, please refer to the Detailed steps tab.

To create a Microsoft SQL Server 2005 instance for ACT! by Sage

1. Insert the ACT! by Sage Premium for Workgroups CD 2 > Windows Explorer or My Computer > browse to the CD > open the SQL Server 2005 Standard\SQL Server 2005\Servers folder > double-click setup.exe.

2. Read the license agreement > select I accept the licensing terms and conditions > Next > Install > when green ticks appear next to all items > Next.

3. Let the configuration check run > Welcome to the Microsoft SQL Server Installation Wizard window > Next > System Configuration Check window > Next.

4. Registration Information window > Name box > ensure the correct name appears > Company box > enter the company name > Next.

5. Components to Install window > select SQL Server Database Services > Next > Instance Name window > select Named instance > Instance name box > enter ACT7 > Next.

6. Next > Service Account window > select Use the built-in System account > choose Local system > select SQL Server > Next.

7. Authentication Mode window select Mixed Mode (Windows Authentication and SQL Server Authentication) > in both Enter password and Confirm password boxes enter sage > Next.

Collation Settings window > select Collation designator and sort order > choose Latin1_General > select Accent sensitive > Next.

To ensure the SQL Server Browse service is running

1. Start > Run > Open box > type services.msc > OK.

Windows 7 and Windows Vista – Start > Start Search box > type services.msc > Enter.

2. Services window > locate SQL Server Browser > check that Started appears in the Status column. If it doesn’t, right-click
the service > Start > File > Exit.

3. Start > All Programs or Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager.

4. SQL Server Configuration Manager window > click SQL Server 2005 Network Configuration > double-click Protocols for
ACT7 > Status column for Named Pipes and TCP/IP column > if Enabled doesn’t appear, select the required line > Action >
Enable.

5. File > Exit.

To update Microsoft SQL Server 2005 to Service Pack 1

1. Visit the Microsoft website at the SQL Server 2005 Service Pack 1 page > follow the instructions to download > Open > Run.

2. Welcome window > Next > read the License Agreement > select I accept the licensing terms and conditions > Next.

3. Feature Selection window > select ACT7 > Next > Authentication Mode window > select All instances and Windows Authentication options are selected > Next.

4. Ready to Install window > Install. If the following windows appear, to continue and return to the Installation Progress window, proceed as follows:
Pending Reboot Files Found – To continue, click Yes.
Computer Reboot Required – To continue, click OK.

5. Next > Installation Complete window > Finish > restart the PC.

For further advice or technical queries

Please contact us on:

01603 516350

enquiry@mintmis.com

www.mintMIS.com

Download the above article in PDF for FREE below