Loading

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

Publiceringsdatum: Jan 27, 2025
Beskrivning

Issue

When attempting to connect to Microsoft SQL Server, the following error occurs:

 

Named Pipes Provider: Invalid parameter(s) found [87]

 

Cause

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

 

Lösning

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 MS SQL Server (no \\ or \).

 

Option 2

Named instance: Specify the computer running MS SQL Server as machineName\instanceName or ipAddress\instanceName.

Note: SQL Server Express Edition is configured by default as a named instance with name SQLEXPRESS.

 

Ytterligare resurser

"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 any of the following errors:

  •  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.

 

Knowledge-artikelnummer

001498376

 
Laddar
Salesforce Help | Article