Enable Named Pipes & TCP for connectivity in SQL Server

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.