Enable Named Pipes & TCP for connectivity in Microsoft SQL Server

Following are the steps to enable Named Pipes & TCP for connectivity:

Note: Downtime activity.

1. Go to the SQL Server Configuration Manager in the SQL Server.
2. On the left panel, expand SQL Server Network Configuration.
3. Select the current SQL SERVER Instance.
4. Enabled the Shared Memory by right click on it, if it’s disabled
5. Enabled the Named Pipes by right click on it, if it’s disabled.
6. Enable the TCP/IP by right click on it, if it’s disabled.
7. Restart the SQL Server Services from services.msc to make the changes effect.