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:
- Enable TCP/IP in SQL Server Configuration Manager → SQL Server Network Configuration → Protocols for SQLEXPRESS node.
- 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.
- Click "Apply" and ensure to restart the SQL Service for the changes to take effect.