CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

 CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:

  • provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    1236
  • Date Created
    Friday, July 9, 2021
  • Last Updated
    Friday, July 9, 2021
  • This Article Has been Viewed
    677 times
  • Short Desc
    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.
  • 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.

    Click on [Connect] from the top left corner of SSMS
    Select [Database Engine]
    From the Dialog
    Type in the [Server Name:]
    [Authentication] Choose [SQL Server Authentication]
    type [as] and the password assigned to your SQL Server instance during installation setup.
    Choose [Connect]

    As long as you provided 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, do the following.
    From the [ServerName\InstanceName]
    --Expand the list.
    [Right-click] on [Security]
    Choose [New]
    Then [Login]
    --Login - New windows opens
    [Login Name:] Type in the name you wish to use to connect to your SS Instance.
    Then choose [SQL Server authentication]
    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]
    Next, click on [Server Roles] from the left TreeView
    Check [sysadmin]
    --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]
    Click [User Mapping]
    Put a check on [master]
    Click [OK]

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles