Unable to execute stored procedure: Named Pipes Provider: Could not open a connection to SQL Server

Document created by sheng_liao462475 Employee on Nov 3, 2016Last modified by chris_stevens on Nov 7, 2016
Version 2Show Document
  • View in full screen mode

Error 

Unable to execute stored procedure: Named Pipes Provider: Could not open a connection to SQL Server

Solution

  1. Verify that the Stored Procedure is calling a valiad server.
  2. Verify that the host in database connection is accessible. 
  3. Enable TCP/IP in SQL Server Configuration.
  4. Open Port 1433 in Windows Firewall.
  5. Enable Remote Connection.
  6. Create an exception for sqlbrowser.exe in Windows Firewall.
  7. Enable SQL Server Browser Service.
  8. Restart MSSQLSERVER service from the server

Attachments

    Outcomes