How do I manually create the Microsoft SQL Server 2016 ACT7 instance?
Product Family: Act!
Product: Act! Pro, Act! Premium, Act! Premium (access via web)
Version: v19.2 and later
Engine: Microsoft SQL Server 2016 Express, Microsoft SQL Server 2016 Standard
Third Party: Microsoft
Note:The following information is provided as a convenience. Swiftpage does not provide support for Microsoft Products. For more information on this topic, go to Microsoft.com
- This article is applicable to both Microsoft SQL Server 2016 Express and Microsoft SQL Server 2016 Standard
- Act! Premium and Act! Premium (access via web) will work with either Microsoft SQL Server 2016 Express or Microsoft SQL Server 2016 Standard, however Act! Pro is only compatible with Microsoft SQL Server 2016 Express.
- You must be logged into Windows as an Administrator in order to install SQL Server 2016
- To avoid additional steps, it is recommended that Act! be uninstalled before creating the ACT7 instance of SQL Server. If you do not wish to uninstall Act!, additional instructions can be found after the section on installing the ACT7 instance.
- It is recommended that any other instances of SQL Server are stopped while manually installing the ACT7 instance. It is also recommended that if using Windows Server 2008 (any edition), that you also disable User Account Control (UAC) (requires rebooting the server). Instructions to disable UAC are in the following knowledgebase article:
How to Change or Disable User Account Control (UAC) in Windows® 7 & Windows Server® 2008
Answer ID: How to Change or Disable User Account Control (UAC) in Windows® 7 & Windows Server® 2008
- If you are currently using Act! in a remote synchronization environment with Microsoft SQL Server 2014, upgrading to Microsoft SQL Server 2016 on the server without also upgrading to Microsoft SQL Server 2016 on the remote computers will break the synchronization. Your server must either be on the same or lower version in order to make sure that synchronization is not interrupted.
Before attempting to install SQL Server 2016, do the following:
- Go to Microsoft.com and review to ensure your system meets the requirements for SQL Server 2016
- Installation Requirements
- System configuration checks
- Security Considerations
Section I: Creating a Microsoft SQL Server 2016 Instance for Act!:
- Depending on which version of Microsoft SQL Server 2016 you are installing, do one of the following:
- Microsoft SQL Server 2016 Express: Download Microsoft SQL Server 2016 from Microsoft Here and execute the file.
- Microsoft SQL Server 2016 Standard: Insert your Microsoft SQL Server 2016 Standard Disc into your CD/DVD drive, then click Install Microsoft SQL Server 2016, or download and execute the install files from Microsoft. If you do not have your disk or do not have your download link, contact Microsoft for assistance.
Note: You may be required to install prerequisites before installing Microsoft SQL Server 2016.
- When the SQL Server Installation Center opens, under Installation, click New SQL Server stand-alone installation or add features to an existing installation
- After the Setup Support Rules checks for any potential system issues, click OK
Note: If you are installing Microsoft SQL Server Standard, you may receive a prompt to enter your Microsoft SQL Server 2016 Standard product key. If it does not automatically populate, enter the product key then click Next. If you do not have your product key, contact Microsoft for assistance.
- When the License Terms dialog box appears, read the terms, check I accept the license terms and then click Next
Note: In some cases, the Setup Support Files will run additional checks to make sure requirements are met. Once these complete, click Next or Install until you reach the Feature Selection Screen
- When the Feature Selection dialog box appears, check the Database Engine Services box and click Next
- On the Instance Configuration screen, select Named instance, enter ACT7 in the Instance name field, then click Next
- In the Server Configuration screen, under the Service Accounts tab, ensure the following settings are configured for SQL Server Database Engine
- Account Name: NT AUTHORITY\SYSTEM
- Startup Type: Automatic
Note: To enter the Account Name, click the field Account Name field, then click the dropdown arrow, then choose Browse. Enter "systeml" into the Enter the object name to select field, then click Check Names and click OK
- Ensure that the SQL Server Browser Startup Type is set to Automatic
- Click the Collation tab, then click Customize…
- Select Windows collation designator and sort order
- For Collation designator, select Latin1_General from the dropdown, ensure Accent-sensitive is the only box checked, then click OK
- When finished configuring the Server Configuration screen, click Next
- In the Database Engine Configuration screen, under the Server Configuration tab, ensure the following settings are configured for each section:
- Authentication Mode:
- Specify the password for the SQL Server system administrator (sa) account:
- Specify SQL Server administrators:
- When finished configuring the Server Configuration tab in the Database Engine Configuration screen, click next
- Review the installation settings, then click Next to proceed with the installation
- Once the installation has completed, click Close
- Restart your computer and log back into the machine as the same Administrator user used to install SQL Server 2016
- On your keyboard, press the Windows key + R, type SQLServerManager13.msc, then press Enter
- Expand SQL Server Network Configuration, then select Protocols for ACT7
- On the right side of the window, right click TCP/IP and select Enable, when the notification window comes up, click OK, then repeat the same action for Named Pipes
- Close the SQL Server Configuration Manager
- On your keyboard, press the Windows key + R, type services.msc, then press Enter
- Locate and right-clickSQL Server (ACT7), then choose Restart
- Ensure that SQL Server Browser is started. If it is not started, right click SQL Server Browser and select Start
- At the bottom of this article download and save the SQL2016_XpCmdShell.bat file
- Run the file and press any key when prompted
- Proceed to the section below that applies to your situation:
- On your keyboard, press the Windows key + R, type cmd, then press Enter
- In the Command prompt, type one of the following commands, depending on the version of Act! and your operating system, then press Enter:
If you have a 32-bit operating system:
- Act! and Act! Premium: cd c:\Program Files\ACT\ACT for Windows
- Act! Premium (access via web): cd c:\Program Files\ACT\ACT for Web
If you have a 64-bit operating system:
- Act! and Act! Premium: cd c:\Program Files (x86)\ACT\ACT for Windows
- Act! Premium (access via web): cd c:\Program Files (x86)\ACT\ACT for Web
- Type SecurityCmdLnApp.exe "xxxx" (excluding the quotes), where xxxx is the SA password you used in step 13 of the "Creating a Microsoft SQL Server 2016 Instance for Act!" section of this article
- After the Command Prompt returns to the C:\ prompt, close the Command Prompt
- Launch Act!
- Launch the installation, and click the option to Install Act! when the installation menu appears
- Proceed with the installation as normal and when prompted, enter the SA password you used in step 13 of the "Creating a Microsoft SQL Server 2016 Instance for Act!" section of this article
Note: For instructions on how to install Act!, refer to the following knowledgebase article depending on your version of Act!:
How do I install Act!?
Answer ID How do I install Act!?