Enable Named Pipes & TCP for connectivity in Microsoft SQL Server
Following are the steps to enable Named Pipes & TCP for connectivity:
Note: Downtime activity.
- Go to the SQL Server Configuration Manager in the SQL Server.
- On the left panel, expand SQL Server Network Configuration.
- Select the current SQL SERVER Instance.
- Enabled the Shared Memory by right click on it, if it’s disabled
- Enabled the Named Pipes by right click on it, if it’s disabled.
- Enable the TCP/IP by right click on it, if it’s disabled.
- Restart the SQL Server Services from services.msc to make the changes effect.