In Apex One’s Database server, ensure its SQL server accepts remote connections over TCP/IP for port 1433. To do this:
- Log into your SQL server through Remote Desktop Connection.
- Click Start and expand the Microsoft SQL Server folder. Select SQL Server Configuration Manager.
- Expand SQL Server Network Configuration then click the Protocols for MSSQLSERVER.
- Right-click TCP/IP and select Properties. Click the IP Addresses tab then scroll down to IPAll. Ensure the TCP Dynamic Ports is blank and TCP Port is set to 1433. Click Apply then OK.
- Restart the SQL Server (MSSQLSERVER) service.
- Test the connection from the Apex One Server to SQL Server on port 1433 via PowerShell.
Success Result:
Ensure that port 1433 is allowed on your firewall.
Mixed mode authentication should be enabled as well for remote connections.
-
Log in to manage Apex Central and deploy VP license again, it should now display:
Activation Code deployed successfully. Please wait for the specified products to activate the license.
