Microsoft SQL Configuration Manager

You can check this opening SQL Server Configuration Manager; this program can be found in Start-menu.

1. Start Microsoft SQL Server Configuration Manager

2. Select Protocols for SQLEXPRESS

3. Double-click top of the TCP/IP

4. Check that TCP/IP is enabled 

5. Click OK

   

6. Open IP addresses tab

7. Find IPALL

8. Remove all numbers TCP Dynamic Ports field

9. When this is done, press OK and you should see the Warning message what is saying that you need to restart the SQL service.

   

   

10. Select SQL Server Services

11. Right mouse click and select Restart