Symptom
Error message:
ODBC connection error
named pipes provider; Could not open a connection to SQL server. Connection failed.
ODBC connection error
named pipes provider; Could not open a connection to SQL server. Connection failed.Resolution
1. Open SQL Server Configuration Manager
2. Expand SQL Server Network Configuration
3. In Protocols for MSSQLSERVER right click on TCP/IP and enable if not enabled then right click and select Properties
4. Select the IP address tab
5. TCP Port should have 1433
6. If this is not specified for each entry (IP1, IP2 etc. all the way to IP-all) add in to each one and apply.
7. On Named pipes, if not enabled enable.
8. Restart the SQL server
Applies To
OnGuard (All versions)
SQL Server (All versions)
Additional Information
None
