A connection was successfully established with the server, but then an error occurred during the pre-login handshake

by

Solution

1) Clean your VS.Net Solution

2) Rebuild Project.

3) Reset IIS

4) Run the project again.

Basically that solved my problem, but in my case i was not getting this error and suddenly my local environment starts giving me above error, so may be that trick work for me.

More Related Contents:

  1. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  2. What’s the best method to pass parameters to SQLCommand?
  3. How to I serialize a large graph of .NET object into a SQL Server BLOB without creating a large buffer?
  4. SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904)
  5. How to serialize a large graph of .NET objects into a SQL Server BLOB without creating a large buffer?
  6. Entity Framework and Connection Pooling
  7. Like Operator in Entity Framework?
  8. Why did a network-related or instance-specific error occur while establishing a connection to SQL Server?
  9. How can I query for null values in entity framework?
  10. What is the correct SQL type to store a .Net Timespan with values > 24:00:00?
  11. How can I solve a connection pool problem between ASP.NET and SQL Server?
  12. Login failed for user ‘DOMAIN\MACHINENAME$’
  13. How to find foreign key dependencies in SQL Server?
  14. Update primary key value using entity framework
  15. Mixed mode assembly is built against version ‘v2.0.50727′ of the runtime
  16. A network-related or instance-specific error occurred while establishing a connection to SQL Server [closed]
  17. Is it necessary to add a @ in front of an SqlParameter name?
  18. Using “GO” within a transaction
  19. How to solve “unable to switch the encoding” error when inserting XML into SQL Server
  20. How to build RUNAS /NETONLY functionality into a (C#/.NET/WinForms) program?
  21. Procedure expects parameter which was not supplied
  22. TSQL md5 hash different to C# .NET md5
  23. How to keep single SQL Server connection instance open for multiple request in C#?
  24. How do I write LINQ’s .Skip(1000).Take(100) in pure SQL?
  25. Unable to load DLL ‘SqlServerSpatial.dll’
  26. Correct way to escape characters in a DataTable Filter Expression
  27. How to store images using Entity Framework Code First CTP 5?
  28. How do I connect to a SQL database from C#?
  29. Using a variable for table name in ‘From’ clause in SQL Server 2008
  30. is it safe to keep database connections open for long time

Leave a Comment