Some custom processes generate errors Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

Products

• Workflow Solution
• ServiceDesk

Issue/Introduction

Error when searching for a contact in a custom form.

 (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Cause

Named pipes not enabled in SQL

Resolution

 

To enable named pipes and TCP/IP for Microsoft SQL Server 2005 or 2008:
Click Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager.
Under SQL Server Network Configuration > Protocols for MSSQLSERVER:
Double-click the protocol name TCP/IP and set the property ENABLED to Yes.
Double-click the protocol name Named Pipes and set the property ENABLED to Yes