Connection to SQL Server Works Sometimes

by

It turned out that TCP/IP was enabled for the IPv4 address, but not for the IPv6 address, of THESERVER.

Apparently some connection attempts ended up using IPv4 and others used IPv6.

Enabling TCP/IP for both IP versions resolved the issue.

The fact that SSMS worked turned out to be coincidental (the first few attempts presumably used IPv4). Some later attempts to connect through SSMS resulted in the same error message.

To enable TCP/IP for additional IP addresses:

  • Start Sql Server Configuration Manager
  • Open the node SQL Server Network Configuration
  • Left-click Protocols for MYSQLINSTANCE
  • In the right-hand pane, right-click TCP/IP
  • Click Properties
  • Select the IP Addresses tab
  • For each listed IP address, ensure Active and Enabled are both Yes.

More Related Contents:

  1. Incorrect syntax near ‘GO’
  2. SQL Server: Isolation level leaks across pooled connections
  3. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  4. Subquery in select not working in SQL Server
  5. Calling stored procedure with return value
  6. Storing images in SQL Server?
  7. How to create jobs in SQL Server Express edition
  8. Retrieve column definition for stored procedure result set
  9. Using varchar(MAX) vs TEXT on SQL Server
  10. SQL Server – Remove all non-printable ASCII characters
  11. Creating audit triggers in SQL Server
  12. Regular Expressions in SQL Server servers?
  13. TSQL Email Validation (without regex)
  14. Dynamic SQL results into temp table in SQL Stored procedure
  15. Connection timeout for SQL server
  16. How to find the port for MS SQL Server 2008?
  17. A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)
  18. TABLOCK vs TABLOCKX
  19. How to convert number of minutes to hh:mm format in TSQL?
  20. What happens if you don’t commit a transaction to a database (say, SQL Server)?
  21. Dynamically assign filename to excel connection string
  22. Temporarily disable all foreign key constraints
  23. SQL Server Dependencies
  24. SQL Server Passthrough query as basis for a DAO recordset in Access
  25. T-SQL query to show table definition?
  26. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  27. Date range overlapping check constraint
  28. Conditional JOIN Statement SQL Server
  29. How do you deal with blank spaces in column names in SQL Server?
  30. ODBC Call Failed with stored procedure – Pass through query

Leave a Comment