KNOWLEDGE BASE

Error "Named Pipes Provider: Invalid parameter(s) found [87]" connecting to Microsoft SQL Server


Published: 27 Feb 2017
Last Modified Date: 10 Nov 2017

Issue

When you try to connect to Microsoft SQL Sever, the following error occurs:
Named Pipes Provider: Invalid parameter(s) found [87]

Environment

  • Tableau Desktop
  • Microsoft SQL Server

Resolution

Change the connection's address via one of the following methods:

Option 1: Default instance

Use only the machine name or IP address of the computer running SQL Server (no \\ or \) 

Option 2: Named instance

Specify the computer running SQL Server as machineName\instanceName or ipAddress\instanceName
Note: SQL Server Express Edition is configured by default as a named instance with name SQLEXPRESS.

Cause

The Invalid Parameter Found message results when using a network path beginning with \\.  This indicates that the connection should used Named Pipes, and that the server is not configured to use Named Pipes.

Additional Information

Named Pipes Provider: Invalid parameter(s) found [87] may not be the only error.  It will be the first error, and may be followed by:

  • Login timeout expired
  • A network-related or instance-specific error has occurred while establishing a connection to SQL Server.  Server is not found or accessible.  Check if instance name is correct and if SQL Server is configured to allow remote connections.  For more information see SQL Server Books Online.
  • Unable to connect to the server "\\path\to\network_location\name_of_Machine".  Check that the server is running and that you have access privileges to the requested database.
Did this article resolve the issue?