SQL SERVER – Fix Connection Error – [Microsoft][ODBC SQL Server Driver][DBNETLIB][ConnectionOpen(Connect()) – Journey to SQL Authority with Pinal Dave

http://blog.sqlauthority.com/2016/12/02/sql-server-fix-connection-error-microsoftodbc-sql-server-driverdbnetlibconnectionopenconnect/

SQL SERVER – Fix Connection Error – [Microsoft][ODBC SQL Server Driver][DBNETLIB][ConnectionOpen(Connect())

….SQL connection from the client application were constantly failing with the following connection error:

[Microsoft][ODBC SQL Server Driver][DBNETLIB][ConnectionOpen(Connect())

We tried below steps to narrow down the issue.

  1. SQL Server instance which we were trying to connect was a named instance, which was listening on non-default port 2433.
  2. SQL Browser was running.
  3. Ping was working fine and we could get the response.
  4. Telnet to port 2433 was working fine.
  5. If we connect using SQLMACHINE\INSTANCE_NAME then it fails.
  6. If we connect using SQLMACHINE,2433 then it works.

At this point we anticipated the UDP port is FILTERED for some reason and hence we are not able to get the instance names mapped to the port numbers.

SOLUTION / WORKAROUND

As a workaround, we went ahead and created the SQL alias for the TCP/IP protocol. Once the alias were created, we could connect to the SQL server successfully using SQLMACHINE\INSTANCE_NAME.

The ideal solution was to make sure the firewall is configured correctly as mentioned in books online Configure the Windows Firewall to Allow SQL Server Access

There could be many other issues of client connectivity and it all depends on error message. Have you encountered a similar error? If yes, what was the solution in your case?

Reference: Pinal Dave (http://blog.sqlauthority.com)

Tags: 

310

Leave a Reply 

https://jetpack.wordpress.com/jetpack-comment/?blogid=107185061&postid=43774&comment_registration=0&require_name_email=1&stc_enabled=1&stb_enabled=1&show_avatars=1&avatar_default=blank&greeting=Leave+a+Reply&greeting_reply=Leave+a+Reply+to+%25s&color_scheme=light&lang=en_US&jetpack_version=4.3.2&sig=4f7c9464b6c55d7bc822f2b624e20ffaf4df9ee1#parent=http%3A%2F%2Fblog.sqlauthority.com%2F2016%2F12%2F02%2Fsql-server-fix-connection-error-microsoftodbc-sql-server-driverdbnetlibconnectionopenconnect%2F

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s