Showing results for 
Search instead for 
Do you mean 

SQL Server 2017?

Copper Contributor
Posts: 28
Country: USA

SQL Server 2017?

Act v20 is compatible with SQL Server 2016.
The current version is SQL Server 2017.
Is anyone successfully using 2017?

John Marshall
Posts: 1,312
Country: United_Kingdom

Re: SQL Server 2017?

Hi John,

We don't claim compatibility with SQL Server 2017 in the current version yet. That's not to say that it doesn't work however, just that v20 hasn't been tested and approved for use with 2017.
Copper Contributor
Posts: 28
Country: USA

Re: SQL Server 2017?


I know - just asking if there is an early adopter out there who has tried it.

John Marshall
Copper Contributor
Posts: 9
Country: United_Kingdom

Re: SQL Server 2017?

For those interested, here are our procedures for installing ACT! 20.1, with SQL Server 2017 on Windows Server 2016.

We have found that ACT! v20.1 does not install nicely first time on Windows Server 2016.


Install Microsoft SQL Server 2017 Express...


  • Click on New SQL Server stand-alone installation
  • Tick I accept the license terms and press Next
  • Tick Use Microsoft Update to check for updates and press Next twice
  • On Install Rules, press Next
  • On Feature Selection, untick SQL Server Replication and press Next
  • On Instance Configuration, select Named instance
  • Type ACT7 as the Named instance
  • Click on Instance ID and press Next
  • On Server Configuration, set…
  • SQL Server Database Engine account name = NT AUTHORITY\SYSTEM
  • SQL Server Browser Startup Type = Automatic
  • Click on Collation tab and press Customize…
  •                 Select Latin1_General and ensure only Accent-sensitive is ticked
  •                 Press Ok and press Next
  • On Database Engine Configuration, select Mixed Mode and type sa password twice press Next
  • Press Close and close SQL Server Installation Center

Restart Server

Run SQLServerManager14.msc

  • Expand SQL Server Network Configuration
  • Select Protocols for ACT7
  • Right click on TCP/IP and select Enable
  • Right click on Named Pipes and select Enable
  • Close SQL Server Configuration Manager

Restart SQL Server (ACT7) service

Check SQL Server Browser service has started

Open Command Prompt (Admin) and run the following batch files

  • SQL2016_XpCmdShell.bat
  • actsqlfirewallports.cmd
  • CreateACTSQLUSERS.bat 

actsqlfirewallports.cmd lists netsh commands to allow SQL ports to be opened on the firewall

CreateACTSQLUSERS.bat is a SQL command file to manually create the default SQL ACT! system accounts with strong passwords

Close Command Prompt


Stop SQL Server (ACT7) service

Install ACT! Microsoft software dependencies

  • Run \ACT! v20.1\Dependencies\vcredist_x86.exe
  • Run \ACT! v20.1\Dependencies\vstor_redist.exe

Restart Server

Run \ACT! v20.1\Setup.exe

Open Actdiag to check ACT! databases

If Act! Diagnostics dialog box does not display, then ACT! has not been successfully installed.  Close Actdiag and then use the following command (run in command windows as Administrator): ResetSQL.bat

  • Press y to Turn off Password Policy
  • Press y to Reset SQL Password

Run Actdiag again

ACT! will need to be uninstalled and reinstalled

  • Open Programs and Features and uninstall ACT! Premium

Restart Server

Reinstall ACT! Premium v20.1

Run \ACT! v20.1\Setup.exe

Open Actdiag to check ACT! databases

Open ACT! Premium on the desktop

Click on File - Restore - Database

  • Select Restore as and press Ok
  • Browse to ACT! and press Ok
  • Type Database Name:  Database
  • Tick Share this database with other users
  • Type Username and Password and press Ok
  • Press Ok when the restore has completed
  • Select Open an existing Act! database and press Ok
  • Select Database and press Open Database
  • Type username and password and press Ok
  • Press No, Press Yes and Press Ok

Run ACT! v20.1 update 6

Good luck to you all.


Nickel Contributor
Posts: 275
Country: United_Kingdom

Re: SQL Server 2017?

Thanks for the install info.