This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided "as is" with no warranties.

Issue

Unable to upgrade client tools components (K2 Studio, K2 Package and Deployment) from the K2 4.7 to K2 5.3 version.

Symptoms

In this scenario, we installed K2 4.7 only client tools on Windows 10, then upgraded to K2 5.1 successfully. When upgrading to K2 5.3, after clicking the next button, the K2 installation console did not move to the next operation. 

validateing client tools

The following error was found in the Installer trace logs:

Could not connect to SQL server. Exception: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Troubleshooting Steps

To resolve this, please do the following:

1. Install Net Core (https://dotnet.microsoft.com/download/dotnet-core/2.1).
2. Enable World Wide Web Service on the machine (Windows Features > World Wide Web Service).
3. Edit the configuration file on your client machine ("C:\Program Files (x86)\K2 blackpearl\Setup\Configuration.config") and update the 'Data Source' to the SQL box. The 'Initial Catalog' might need to be updated to the correct database name.

<configurationdatabase>
<add key="connectionString" value="Data Source=[K2 database server];Initial Catalog=K2;Integrated Security=True;Pooling=True" />
<add key="ShowAllUI" value="false" />

4. Run the installer to upgrade to the 5.3 version.