Error message: (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.)

by

Typically, to troubleshoot this, you go to SQL Server Configuration Manager (SSCM) and:

  1. ensure Shared Memory protocol is enabled
  2. ensure Named Pipes protocol is enabled
  3. ensure TCP/IP is enabled, and is ahead of the Named Pipes in the settings

Maybe it can help: Could not open a connection to SQL Server

Note : If this is a new instance of SQL Server be sure SQL Server and Windows Authentication is enabled

  1. Right Click the Server in SSMS and pull up server properties
  2. Go to Security–> Select ‘SQL Server and Windows Authentication Mode’
  3. Restart the Server and Login with the credentials

More Related Contents:

  1. Where is |DataDirectory| defined?
  2. efficient way to implement paging
  3. COUNT MANY FIELDS IN ACCESS [closed]
  4. Insert into … values ( SELECT … FROM … )
  5. IN vs OR in the SQL WHERE Clause
  6. How should I pass a table name into a stored proc?
  7. How to handle a single quote in Oracle SQL
  8. What’s the difference between DoCmd.SetWarnings and CurrentDB.Execute
  9. SQL Join Differences
  10. Get the week start date and week end date from week number
  11. Why is using ‘*’ to build a view bad?
  12. Sql Server deterministic user-defined function
  13. SELECT FOR UPDATE with SQL Server
  14. Get top row(s) with highest value, with ties
  15. Is it true that using INNER JOIN after any OUTER JOIN will essentially invalidate the effects of OUTER JOIN?
  16. How to group by month from Date field using sql
  17. Reference an alias elsewhere in the SELECT list
  18. SQL update fields of one table from fields of another one
  19. ORA-00907: missing right parenthesis
  20. Android multiple databases open
  21. Table or column name cannot start with numeric?
  22. SQL Row_Number() function in Where Clause
  23. Is there a version control system for database structure changes?
  24. Find all records which have a count of an association greater than zero
  25. PostgreSQL column ‘foo’ does not exist
  26. Oracle: Updating a table column using ROWNUM in conjunction with ORDER BY clause
  27. What is the meaning of SELECT … FOR XML PATH(‘ ‘),1,1)?
  28. SQL Sort Order with Null values last
  29. SQLite query, ‘LIKE’
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment