Text and meaning of the error

Such an error can occur when working with the Execute query activity. The error message can look like this:

Solution

To solve this error, you need to do the following:

1. Enable TCP/IP in SQL Server Configuration Manager → SQL Server Network Configuration → Protocols for SQLEXPRESS node.
   
   
2. In the "IP Addresses" tab of the "TCP/IP Properties" page, scroll down to IPAll and clear any value present for TCP Dynamic Ports and provide the value 1433 in the TCP Port.
   
   
   
3. Click "Apply" and ensure to restart the SQL Service for the changes to take effect.