SQL Server – TCP/IP error connection

By | 24/08/2022

In this post, we will see how to fix a possible error of connection that we could have trying to connect at SQL Server using TCP/IP.
For this post, I have installed SQL Server 2019 Express edition and SQL Server Management Studio.
I have created a password for the sa user and I can connect using all these “Server name”:



computer name

But, if I try to connect using as Server name, I receive this error:

In order to fix this problem, we have to check that TCP/IP is enabled in Sql Server Configuration Manager.
First of all, we open Microsoft Management Console writing mmc in start menu:

Then, we click on File->Add/remove Snap-in:

Finally, we select Sql Server Configuration Manager, we push Add and then we click on Ok:

Now, we open “SQL Server Configuration Manager”, we select TCP/IP (we can see that it is disabled…) and then we enabled it:

Finally, we restart Sql Server service and then we try to connect using as “Server name”:

Leave a Reply

Your email address will not be published. Required fields are marked *