SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904)

I am seeing this in several situations and it is intermittent in our web based application connecting to SQL 2008 R2 serve back end. Users are coming across a point 2 point connection and seeing this on and off. Thought it was bandwidth issues until I started seeing it on terminal servers that are on the same core switch as this SQL server. I have checked remote connection enabled, Port 1433 is set correctly in Configuration for TCP/IP and the only thing I see that could be a cause is the timeout setting is set to 100000 in the remote connections rather than unlimited.

The error is

System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) --->

System.ComponentModel.Win32Exception (0x80004005): The network path was not found at

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection, Action`1 wrapCloseInAction) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo,
SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout,
Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean
integratedSecurity, Boolean withFailover) at
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, SecureString newSecurePassword,
Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean
withFailover) at
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo
serverInfo, String newPassword, SecureString newSecurePassword,
Boolean redirectedUserInstance, SqlConnectionString connectionOptions,
SqlCredential credential, TimeoutTimer timeout) at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer
timeout, SqlConnectionString connectionOptions, SqlCredential
credential, String newPassword, SecureString newSecurePassword,
Boolean redirectedUserInstance) at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, SqlCredential
credential, Object providerInfo, String newPassword, SecureString
newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString
userConnectionOptions, SessionData reconnectSessionData) at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningConnection,
DbConnectionOptions userOptions) at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool
pool, DbConnection owningObject, DbConnectionOptions options,
DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject, DbConnectionOptions userOptions, DbConnectionInternal

Related Posts:

  1. What’s the difference between .NET Core, .NET Framework, and Xamarin?
  2. What is a singleton in C#?
  3. ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
  4. T-SQL split string
  5. Rename column SQL Server 2008
  6. Efficiently convert rows to columns in sql server
  7. My C# application is returning 0xE0434352 to Windows Task Scheduler but it is not crashing
  8. What is WCF? and what can it do?
  9. C# Set collection?
  10. T-SQL split string based on delimiter
  11. Difference between Delphi and Delphi.NET
  12. SQL Server Management Studio, how to get execution time down to milliseconds
  13. Where/how can I download (and install) the Microsoft.Jet.OLEDB.4.0 for Windows 8, 64 bit?
  14. Convert Enum to String
  15. An attempt was made to access a socket in a way forbidden by its access permissions
  16. Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
  17. Windows Application has stopped working :: Event Name CLR20r3
  18. Why is Dictionary preferred over Hashtable in C#?
  19. What is the difference between ASP.NET MVC 6 and ASP.NET Core 1.0 and the reason behind the core framework?
  20. Embed a System.String in XAML
  21. What’s the difference between struct and class in .NET?
  22. Does anyone still use [goto] in C# and if so why?
  23. How does the “Using” statement translate from C# to VB?
  24. Where Is Machine.Config?
  25. Why does .Net Socket.Disconnect take two minutes?
  26. ClickOnce runtime DFSVC.EXE
  27. “An attempt was made to load a program with an incorrect format” even when the platforms are the same
  28. What is the best way to parse html in C#? [closed]
  29. Best C# API to create PDF
  30. How can I truncate a datetime in SQL Server?
  31. How can I delete using INNER JOIN with SQL Server?
  32. C# cannot convert method to non delegate type
  33. What is the difference between const and readonly in C#?
  34. Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
  35. SQL Server Insert if not exists
  36. SQL Server: Invalid Column Name
  37. How can I get column names from a table in SQL Server?
  38. Cannot send a content-body with this verb-type
  39. Html.Partial vs Html.RenderPartial & Html.Action vs Html.RenderAction
  40. Pass Method as Parameter using C#
  41. Nuget connection attempt failed “Unable to load the service index for source”
  42. Cannot access a disposed object – How to fix?
  43. MS SQL compare dates?
  44. HashSet vs. List performance
  45. Cannot access a disposed object – How to fix?
  46. MS SQL compare dates?
  47. How do I fix ‘Invalid character value for cast specification’ on a date column in flat file?
  48. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  49. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  50. ArrayList vs List<> in C#
  51. How to access Session variables and set them in javascript?
  52. What’s the @ in front of a string in C#?
  53. What is the maximum characters for the NVARCHAR(MAX)?
  54. Using RegEx in SQL Server
  55. How to solve ‘…is a ‘type’, which is not valid in the given context’? (C#)
  56. Could not load file or assembly App_Web_ * with a precompiled ASP.NET website project
  57. How should I cast in VB.NET?
  58. Calling the base constructor in C#
  59. Warning: Found conflicts between different versions of the same dependent assembly
  60. Best way to repeat a character in C#
  61. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  62. Bulk load data conversion error (truncation)
  63. Connection string using Windows Authentication
  64. What is the purpose ApplicationDbContext Class in (under IdentityModels.cs file) ASP.NET MVC 5?
  65. How to solve “Could not establish trust relationship for the SSL/TLS secure channel with authority”
  66. How to empty a list in C#?
  67. What is The difference between ListBox and ListView
  68. SQLite equivalent to ISNULL(), NVL(), IFNULL() or COALESCE()
  69. Could not establish secure channel for SSL/TLS with authority ‘*’
  70. sql query to return differences between two tables
  71. Cannot attach the file *.mdf as database
  72. How to open an Excel file in C#?
  73. Errors: “INSERT EXEC statement cannot be nested.” and “Cannot use the ROLLBACK statement within an INSERT-EXEC statement.” How to solve this?
  74. What is a method group in C#?
  75. How can I download a file with batch file without using any external tools?
  76. Backup a single table with its data from a database in sql server 2008
  77. How do I save a stream to a file in C#?
  78. Print Pdf in C#
  79. Can a Byte[] Array be written to a file in C#?
  80. Entity Framework vs LINQ to SQL
  81. .NET Framework 4.6 or a later update is already installed on this computer
  82. How can I group by date time column without taking time into consideration
  83. Retrieving the COM class factory for component with CLSID {XXXX} failed due to the following error: 80040154
  84. How do I find the PublicKeyToken for a particular dll?
  85. What are named pipes?
  86. How to select the last record of a table in SQL?
  87. Could not find any resources appropriate for the specified culture or the neutral culture
  88. Consider app.config remapping of assembly with no app.config mapping
  89. Comma separated results in SQL
  90. What is a “first chance exception”?
  91. SHOWPLAN permission denied in database ‘tempdb’. in sql server 2008
  92. What is the difference between String and string in C#?
  93. Filter data based on date in sql
  94. Varchar invalid for Sum operator
  95. Creating a List of Lists in C#
  96. A certificate chain could not be built to a trusted root authority
  97. C# int to byte[]
  98. INQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria
  99. How to connect to database from Unity
  100. Access to the path is denied

Leave a Comment