Community
Showing results for 
Search instead for 
Do you mean 
Reply

SQL Server 2017?

Copper Contributor
Posts: 29
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?
Thanks.

John Marshall
Administrator
Posts: 1,372
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: 29
Country: USA

Re: SQL Server 2017?

Jon,

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

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...

Run SQLServer2017\SQLEXPR_x64_ENU\SETUP.EXE

  • 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! Database.zip 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.

LF

Nickel Super Contributor
Posts: 325
Country: United_Kingdom

Re: SQL Server 2017?

Thanks for the install info.

Copper Super Contributor
Posts: 163
Country: USA

Re: SQL Server 2017?

[ Edited ]

I could not find the file actsqlfirewallports.cmd anywhere so I created my own script for adding the rules into the firewall as mentioned in KB 25125

 

@echo Lookup the TCPIP port in start - run - actdiag - server - server security and enter it here
set /p actdiagsec="Lookup actdiag server server security TCPIP: "


@echo open ports
netsh advfirewall firewall add rule name="SQLServer" dir=in action=allow protocol=TCP localport=1433
netsh advfirewall firewall add rule name="SQL Browser" dir=in action=allow protocol=TCP localport=1434
netsh advfirewall firewall add rule name="Default Port for Universal Search" dir=in action=allow protocol=TCP localport=8112
netsh advfirewall firewall add rule name="HTTP" dir=in action=allow protocol=TCP localport=80
netsh advfirewall firewall add rule name="HTTPS" dir=in action=allow protocol=TCP localport=443
netsh advfirewall firewall add rule name="Act! registration" dir=in action=allow protocol=TCP localport=1690
netsh advfirewall firewall add rule name="Act! Connect link and API" dir=in action=allow protocol=TCP localport=22
netsh advfirewall firewall add rule name="Act! Network synchronisation" dir=in action=allow protocol=TCP localport=65100
netsh advfirewall firewall add rule name="ActDiag Server ServerSecurity"" dir=in action=allow protocol=TCP localport=%actdiagsec%



@echo Act! exception rules
netsh advfirewall firewall add rule name="Act!.exe" dir=in action=allow program="C:\Program Files (x86)\ACT\ACT for Web\Act!.exe" enable=yes
netsh advfirewall firewall add rule name="Act!Local Act! Preferences location" dir=in action=allow program="C:\Users\administrator\AppData\Roaming\ACT\ACT Data" enable=yes
netsh advfirewall firewall add rule name="ACT Email.exe" dir=in action=allow program="C:\Program Files (x86)\ACT\ACT for Web\ACTEmail.exe" enable=yes
netsh advfirewall firewall add rule name="Act.Outlook.Service.exe" dir=in action=allow program="C:\Program Files (x86)\ACT\ACT for Web\Act.Outlook.Service.exe" enable=yes
netsh advfirewall firewall add rule name="Act.Outlook64.Service.exe" dir=in action=allow program="C:\Program Files (x86)\ACT\ACT for Web\Act.Outlook64.Service.exe" enable=yes
netsh advfirewall firewall add rule name="Act.Integration.exe" dir=in action=allow program="C:\Program Files (x86)\ACT\ACT for Web\Act.Integration.exe " enable=yes
netsh advfirewall firewall add rule name="Act ISPA.exe" dir=in action=allow program="C:\Program Files (x86)\ACT\Act for Web\Integration Services Patch for Act!\ISPA.exe" enable=yes
netsh advfirewall firewall add rule name="Act.Scheduler.exe" dir=in action=allow program="C:\Program Files (x86)\ACT\ACT for Web\Act.Scheduler.exe" enable=yes
netsh advfirewall firewall add rule name="Act.Framework.Synchronization.Service.exe" dir=in action=allow program="C:\Program Files (x86)\ACT\ACT for Windows\ACT Network Sync\Act.Framework.Synchronization.Service.exe" enable=yes
netsh advfirewall firewall add rule name="Act.Framework.Synchronization.Service.UI.exe" dir=in action=allow program="C:\Program Files (x86)\ACT\ACT for Windows\ACT Network Sync\Act.Framework.Synchronization.Service.UI.exe" enable=yes
netsh advfirewall firewall add rule name="Act.Server.Host.exe" dir=in action=allow program="C:\Program Files (x86)\ACT\Act for Web\Act.Server.Host.exe" enable=yes
netsh advfirewall firewall add rule name="Act Protexislicensing" dir=in action=allow program="C:\Program Files (x86)\Common Files\Protexis\License Service\PsiService_2.exe" enable=yes




@echo SQLSERVER exception rules
netsh advfirewall firewall add rule name="SQLSERVR.exe" dir=in action=allow program="C:\Program Files\Microsoft SQL Server\MSSQL12.ACT7\MSSQL\Binn\SQLSERVR.exe" enable=yes
netsh advfirewall firewall add rule name="SQLBrowser.exe" dir=in action=allow program="C:\Program Files\Microsoft SQL Server\90\Shared\SQLBrowser.exe" enable=yes


pause

 Hope this might help anyone.

Thanks,
Inge van Gemert
ACT! Certified Consultant
The Netherlands
inge@inkey.net