Question:
How do I manually create the Microsoft SQL Server 2014 ACT7 instance?
Product:
Product Family: Act!
Product: Act! Pro, Act! Premium, Act! Premium (access via web)
Version: v17.1 and later
Environment:
Engine: Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Standard
Third Party: Microsoft
Answer:
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
Prior to installing the Microsoft SQL Server 2014 ACT7 instance, it is recommended that you read the following knowledgebase article:
Frequently Asked Questions about using Act! v17.1 with Microsoft SQL Server 2014
Answer ID Frequently Asked Questions about using Act! v17.1 and later with Microsoft SQL Server 2014
Important Notes:
- This article is applicable to both Microsoft SQL Server 2014 Express and Microsoft SQL Server 2014 Standard
- Act! Premium and Act! Premium (access via web) will work with either Microsoft SQL Server 2014 Express or Microsoft SQL Server 2014 Standard, however Act! Pro is only compatible with Microsoft SQL Server 2014 Express.
- You must be logged into Windows as an Administrator in order to install SQL Server 2014
- 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
Before attempting to install SQL Server 2014, do the following:
- Go to Microsoft.com and review to ensure your system meets the requirements for SQL Server 2014
- Installation Requirements
- System configuration checks
- Security Considerations
- Apply latest Windows Updates for your installed version of Windows
Section I: Creating a Microsoft SQL Server 2014 Instance for Act!:
- Depending on which version of Microsoft SQL Server 2014 you are installing, do one of the following:
- Microsoft SQL Server 2014 Express: Download Microsoft SQL Server 2014 from Microsoft Here and execute the file.
- Microsoft SQL Server 2014 Standard: Insert your Microsoft SQL Server 2014 Standard Disc into your CD/DVD drive, then click Install Microsoft SQL Server 2014, 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 2014. - 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 2014 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 drop-down arrow, then choose Browse. Enter "system" 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: Choose Mixed Mode
- Specify the password for the SQL Server system administrator (sa) account: Type a password in the Enter Password and the Confirm password fields and make a note of this password as it will be used further down in this article
- Specify SQL Server administrators: Click Add Current User
- When finished configuring the Server Configuration tab in the Database Engine Configuration screen, click next
- 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 2014
- Click the Start menu, type SQLServerManager12.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
- Click the Start menu, 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 SQL2014_XpCmdShell.bat file
- Run the file and press any key when prompted
- Proceed to the section below that applies to your situation:
Act! is already installed: Connecting the SQL Server ACT7 instance to Act!
- Click the Start menu, 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 2014 Instance for Act!” section of this article
- After the Command Prompt returns to the C:\ prompt, close the Command Prompt
- Launch Act!
Act! is not installed yet: Installing 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 2014 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!?