Provider named pipes provider error 40 could not open a connection to SQL Server error 2 [duplicate]

by

Well I have an easy solution for your question. Follow the steps:

  1. Go to SQL Server Configuration manager
  2. SQL Server Network Configuration:
  3. Protocol for MSSQLSERVER
  4. In the right pane split page you will have to disable VIA as follows
    1. Shared Memory – Enable
    2. Named Pipes – Enable
    3. TCP/IP – Enable
    4. VIA – Disable

More Related Contents:

  1. Delete from two tables? [closed]
  2. Procedure or function xxxxx has too many arguments specified [duplicate]
  3. An unhandled exception of type ‘System.InvalidOperationException’ occurred in System.Data.dll?
  4. How to execute a stored procedure within C# program
  5. Using stored procedure output parameters in C#
  6. How can I set an SQL Server connection string?
  7. Insert entire DataTable into database at once instead of row by row?
  8. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  9. I get a “An attempt was made to load a program with an incorrect format” error on a SQL Server replication project
  10. SQL error: Incorrect syntax near the keyword ‘User’
  11. How to execute an SSIS package from .NET?
  12. Passing List to SQL Stored Procedure
  13. How to retrieve data from a SQL Server database in C#?
  14. Bulk Update in C#
  15. How to run multiple SQL commands in a single SQL connection?
  16. Queuing in OneWay WCF Messages using Windows Service and SQL Server
  17. Any way to SQLBulkCopy “insert or update if exists”?
  18. EF 6 – How to correctly perform parallel queries
  19. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  20. What SqlDbType maps to varBinary(max)?
  21. How to keep single SQL Server connection instance open for multiple request in C#?
  22. Delete a single record from Entity Framework?
  23. How to pass XML from C# to a stored procedure in SQL Server 2008?
  24. How to use SqlCommand to CREATE DATABASE with parameterized db name?
  25. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  26. Failed to update .mdf database because the database is read-only (Windows application)
  27. What size do you use for varchar(MAX) in your parameter declaration?
  28. GO statements blowing up sql execution in .NET
  29. How to Identify the primary key duplication from a SQL Server 2008 error code?
  30. Watch for a table new records in sql database

Leave a Comment