Some custom processes generate errors Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
book
Article ID: 156044
calendar_today
Updated On:
Products
Workflow SolutionServiceDesk
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