How to test the installation of the Microsoft SQL Server for ACT! 2010 and below

Summary

If during the ACT! installation, Microsoft SQL Server 2005 Express Edition didn’t install or a SQL ACT7 instance wasn’t created,
one of the following messages may appear:

  • Could not connect to the SQL Server Instance
  • Failed to open a connection to the database
  • Cannot create a new database
  • Cannot open the demo database

This article explains how to test the installation of the Microsoft SQL Server for ACT!.

Answer

These are the basic steps that explain how to test the installation of the Microsoft SQL Server for ACT! by Sage. They include:

  • To check the SQL Server has installed
  • To check the log files for failed install items
  • To remove installed components
  • To check the configuration of the SQL Server
  • To check the SQL Service is running
  • To install and run SQL Installer.exe

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

To check the SQL Server has installed

1. Start > Settings > Control Panel > double-click Add / Remove Programs > check the list of programs for Microsoft SQL Server 2005.

Windows 7 and Windows Vista – Click Start > Control Panel > double-click Programs and Features > check the list of programs for Microsoft SQL Server 2005.

2. Right-click the Add / Remove Programs or Programs and Features window name Close > File > Close.

Windows 7 and Windows Vista – Hold down the left Alt key > File > Close > File > Close.

3. If Microsoft SQL Server isn’t in the list of programs > install and run SQL Installer.exe.

To check the log files for failed install items

1.       Browse to C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log > double-click Summary.txt > check the Install message for each section.
Example:


Microsoft SQL Server 2005 9.00.2170.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Tue Sep 26 14:28:31 2006

Machine : SAGE-12B04A9624
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAGE-12B04A9624_SQLSupport_1.log

————————————————————————-

To remove installed components

Note: If one or more of the install components have failed you must remove all components then reinstall SQL Server and ACT!

1. Start > Settings > Control Panel > Add / Remove Programs.

Windows 7 and Windows Vista – Start > Control Panel > Programs and Features.

3. Locate and select the following files > Remove > Yes > Yes.

MSXML 6.0 Parser

Microsoft SQL Server Setup Support Files (English)

Microsoft SQL Server Native Client

Microsoft SQL Server VSS Writer

3. If listed > select Microsoft SQL Server 2005 > Remove > Uninstaller Error window > Yes.

To check the SQL Server configuration

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

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

2. Locate SQL Server (ACT7) > if it appears refer to the following section > if it doesn’t appear > File > Exit.

3. Start > Run > Open box > type actdiag > OK.

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

4. ACT! Diagnostics window > Server > Server Security > Reset SQL Password > Yes > OK > open ACT!:

If ACT! opens, you don’t need to proceed any further.

If ACT! doesn’t open > ACT! Diagnostic window > File > Exit > double-click My Computer > browse to the following location:

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

5.      Double-click ERRORLOG > check for Authentication Errors for SA or ACTAdmin when the SQL Service was started > File > Exit.

2006-09-10 11:21:31.04 Server Microsoft SQL Server 2005 – 9.00.2170.00 (Intel X86)
Jun 28 2006 15:24:03
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2006-09-10 11:21:31.04 Server (c) 2005 Microsoft Corporation.
2006-09-10 11:21:31.04 Server All rights reserved.
2006-09-10 11:21:31.04 Server Server process Failed
2006-09-10 11:21:31.04 Server Logging SQL Server Not Authenticated.
2006-09-10 11:21:32.53 Server A self-generated certificate was unsuccessful.

Tip: Up to six log files are created each time a SQL Instance is started.

6. If the above error appears > configure a new ACT7 instance. For further information, please refer to article 14964 .

To check the SQL Service is running

1. Start > Run > type actdiag > OK.

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

If the ACT! Diagnostic window opens and no messages appear, the SQL Service is running.

2. Restart the PC > if you can’t open ACT!, manually restart the SQL Service.

3. To do this: Start > Run > Open box > type services.msc > OK.

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

4. Services window > right-hand pane > locate and select SQL Server (ACT7) > right-click > Start > File > Exit.

If SQL Server (ACT7) isn’t listed – Please refer to the following section, To install and run SQL Installer.exe .

To install and run the SQL Installer.exe

Note: The following information is provided as a guide. Sage (UK) Limited do not provide support for Microsoft Products.

1. Insert the ACT! Installation CD > My Computer > double-click the CD drive.

Windows 7 and Windows Vista – Insert the ACT! CD > Start > Computer > double-click the CD drive.

2. Dependencies folder > double-click SQL Install.exe > read the disclaimer > OK > OK.

3.      Browser window > enter the path to the Dependencies folder in the ACT! program folder > Continue.

         Tip: If required, to browse to the folder, click the finder button.

4.      When the SQL Server setup and Microsoft SQL Server 2005 Setup have finished, and all the components required for the SQL Server Setup have been installed, click Install.

Note: If Failed appears in the Status column of any of the Action items the installation stops. Information about the failure appears in the Message column.

5. In the System Configuration Check window, to continue, click Next then in the SQL Express install is complete window, for future reference, note the location of the installation log files then click OK.

Tip: If required, to read the log file now, select the Click here to view the log file check box then click OK.

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