KB Issue
Logging into SQL Server Management Studio with Windows Authentication can cause the Named Pipes Provider error 0 if you connect from a server in your network.
Issue Details
Connecting to SQL Server instance using SQL Server Management Studio or SSMS from a network computer without the proper authentication will cause the Named Pipes Provider error 0.
Recreate Issue
Trying to connect to a SQL Server Instance from SQL Server Management Studio from a networking computer without proper user authentication.
Resolve Issue
To get past this error, you will need to provide your login credentials from your SQL Server User to gain access to SSMS from a networking computer.
  1. Click on [Connect] from the top left corner of SSMS
  2. Select [Database Engine]
  3. From the Dialog
    Type in the [Server Name:]
  4. [Authentication] Choose [SQL Server Authentication]
  5. type [as] and the password assigned to your SQL Server instance during installation setup.
    Choose [Connect]
As long as you provide the proper password, the SA account will let you in.
Once logged in, you will need to create a new login user account for your SQL Server Instance.
[To create a new SS User]
  1. From the [ServerName\InstanceName]
    2. Expand the list
  2. [Right-click] on [Security]
  3. Choose [New]
  4. Then [Login]
    5. Login - New window opens
  5. [Login Name:] Type in the name you wish to use to connect to your SS Instance.
  6. Then choose [SQL Server authentication]
  7. Type in your password, make it a good one, and then confirm it.
    If you do not think it will authenticate, then uncheck [Enforce password policy]
  8. Next, click on [Server Roles] from the left TreeView
  9. Check [sysadmin]
  10. This next part is only if the user will be creating databases and performing database creation duties like working with [Always On High Availability] or [AOHA]
  11. Click [User Mapping]
  12. Put a check on [master]
  13. Click [OK]