SQL Protocols

Topics from the Microsoft SQL Server Protocols team - Netlibs, TDS, SQL Browser, etc...

Announcing Microsoft SQL Server ODBC Driver for Linux

Greetings Developer community: We heard yesterday and today at the PASS conference about the...

Author: dpblogs Date: 10/13/2011

Annual SQL Connectivity Customer Survey

Greetings to the Developer community: Microsoft SQL Server team has been interacting on a regular...

Author: dpblogs Date: 08/17/2011

Last Chance: Help Shape The Future Of SQL Server!

Hello reader,We have extended our SQL Connectivity Customer Survey until November 2, 2010 5:00PM...

Author: SQL Server Connectivity Date: 10/29/2010

SQL Server Customer Survey (Fall 2010)

Greetings to the SQL Server community: Last year in October 2009, we introduced the process of...

Author: SQL Server Connectivity Date: 10/12/2010

Windows 7 AppCompat changes and SQL Server client and setup hangs

Windows 7 and Windows Server 2008 R2 include many changes to the core operating system. This blog...

Author: SQL Server Connectivity Date: 08/13/2010

SQL Server "Login Failure" troubleshooter

Our colleagues over in the SQL Server Security team have developed an open tool for troubleshooting...

Author: SQL Server Connectivity Date: 04/02/2010

SQL Server Native Client survey

Dear SQL Server developers and users:Our sister team, the SQL Server Native Client (SNAC), has a...

Author: dpblogs Date: 01/16/2010

Selectively using secure connection to SQL Server

Secure connection to SQL Server can be enforced by different ways, e.g. forcing encryption by using...

Author: SQL Server Connectivity Date: 10/19/2009

We would like to hear your opinion...

Dear SQL Server developers and users: It is this time of the year when we, in the SQL Connectivity...

Author: dpblogs Date: 10/02/2009

Connection from a Windows Service could be blocked by firewall even if firewall is disabled

Recently, I worked on a customer issue. The customer encountered an "error: 26 - Error Locating...

Author: SQL Server Connectivity Date: 09/21/2009

Understanding the error “An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.”

This error message, which is associated with the Winsock error WSAENOBUFS and actually comes from...

Author: SQL Server Connectivity Date: 03/09/2009

TCP listening ports and ENDPOINT ports behavior

Endpoint configuration seems to be creating some confusion. I hope that this will clarify some of...

Author: SQL Server Connectivity Date: 11/05/2008

Understanding “Data Source=(local)” in SQL Server Connection Strings

Lately we have noticed many misunderstandings surrounding the usage of the Data Source keyword in...

Author: SQL Server Connectivity Date: 09/19/2008

Configuring SQL Protocols through Windows PowerShell

Sometimes we are asked about the possibility of configuring SQL Server protocols through PowerShell....

Author: SQL Server Connectivity Date: 08/28/2008

Connection failure because of mismatched TDS version

Some customers have reported connection failure because of wrong TDS version. The client application...

Author: SQL Server Connectivity Date: 07/15/2008

Troubleshooting SQL Server Cluster Installations

On a Windows Cluster it is possible to install a SQL Server Cluster, which will be a separate entity...

Author: SQL Server Connectivity Date: 06/16/2008

Connectivity troubleshooting in SQL Server 2008 with the Connectivity Ring Buffer

SQL Server 2008 contains a new feature designed to help troubleshoot particularly tricky...

Author: SQL Server Connectivity Date: 05/20/2008

Understanding the error message: “Login failed for user ''. The user is not associated with a trusted SQL Server connection.”

Understanding the error message: “Login failed for user ''. The user is not associated with a...

Author: SQL Server Connectivity Date: 05/02/2008

Steps to troubleshoot SQL connectivity issues

We have been seeing and trying to resolve SQL connectivity issue all the time. I guess it would be...

Author: SQL Server Connectivity Date: 04/30/2008

Could not connect to X64 named instance

We see a couple of cases where customer could not connect to named instance on X64. They all have...

Author: SQL Server Connectivity Date: 04/20/2008

Understanding “Connection forcibly closed by remote host” Errors Caused by TOE/Chimney

Sporadic “Connection forcibly closed by remote host” errors with SQL Server connections...

Author: SQL Server Connectivity Date: 04/08/2008

Why Browser is installed under 90shared directory rathar than 100Shared?

After installing SQL Server 2008, some users might notice that sqlbrowser.exe is installed under...

Author: SQL Server Connectivity Date: 04/07/2008

Service Principal Name (SPN)

Did you know that beginning with SQL Server 2008, support for service principal names (SPNs) has...

Author: SQL Server Connectivity Date: 04/02/2008

TCP Provider: No connection could be made because the target machine actively refused it

In this post, I am trying to list out potential cause and general solution to this specific error...

Author: SQL Server Connectivity Date: 07/19/2007

Login failed for user , Msg 18456, Level 14, State 1

This post focus on a typical cause of sql login failure issue described as the title. In real world,...

Author: SQL Server Connectivity Date: 06/30/2007

SSL Cipher Suites used with SQL Server

When enabling channel encryption between the application and SQL Server, users may wonder what...

Author: SQL Server Connectivity Date: 06/29/2007

Install a self-signed test certificate that can be loaded by SQL Server automatically

In the blog Certificate for SQL Server 2005, I explained the requirements of a certificate for SQL...

Author: SQL Server Connectivity Date: 06/27/2007

Connecting to SQL Server 2005 on Vista and Longhorn

Some customers have experienced problems connecting to SQL Server 2005 on Vista and Longhorn. Even...

Author: SQL Server Connectivity Date: 06/18/2007

Named Pipes Provider, error: 40 - Could not open a connection to SQL Server (Microsoft SQL Server, Error: XXX)

This error message is the most frequent error message when connecting to SQL Server. You see this...

Author: SQL Server Connectivity Date: 05/16/2007

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

Users often see this error message when connection to a SQL Server and don't know where to start to...

Author: SQL Server Connectivity Date: 05/13/2007

Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

This error was most frequently hitted by our customers, and in this post, give a brief summary of...

Author: SQL Server Connectivity Date: 03/31/2007

Building a WebMethod FORMAT=NONE Stored Procedure

Commonly for Web Services, the exposed interfaces (webmethods) must conform to some pre-defined...

Author: SQL Server Connectivity Date: 02/25/2007

TDSSNIClient initialization failed with error 0x50, status code 0x50

In this post, I want to talk about a special cause of this specific error message when you try to...

Author: SQL Server Connectivity Date: 01/31/2007

Connection Alias

SQL Server client stack has a facility to let user define connection aliases. Connection Alias can...

Author: SQL Server Connectivity Date: 01/07/2007

"Cannot Generate SSPI Context" error message, Poisoned DNS

Incorrect DNS can lead to various network connectivity issues. In this post, I explain how it...

Author: SQL Server Connectivity Date: 01/02/2007

Understanding Kerberos and NTLM authentication in SQL Server Connections

In this post, I focus on how NTLM and Kerberos are applied when connecting to SQL Server 2005 and...

Author: SQL Server Connectivity Date: 12/02/2006

Building T-SQL Custom WSDL generator

We've gotten feedback from customers who have asked if it is possible to write a custom WSDL...

Author: SQL Server Connectivity Date: 11/07/2006

SQL Server 2005 Remote Connectivity Issue TroubleShoot

With shipping SQL Server 2005, we heard from customer feedback about suffering make successful...

Author: SQL Server Connectivity Date: 09/30/2006

SQL Linked Server Query failed with “Login failed for user …”

SQL Server 2005: “Login failed for user 'NT AUTHORITYANONYMOUS LOGON'”. SQL Server 2000:...

Author: SQL Server Connectivity Date: 08/10/2006

Troubleshooting Netlib that Comes with MDAC2.8 SP1/NET1.0, SNAC, SQL Server 2005 and NET 2.0 with ETW Tracing

Ever have issue with GNE (general network error)? Using ETW tracing can help. For feature...

Author: SQL Server Connectivity Date: 08/04/2006

"No process is on the other end of pipe" caused by bad certificate

In this blog, I am focusing on one specific error message which I think a little confusing for you...

Author: SQL Server Connectivity Date: 07/26/2006

Error Messages of SQL Server 2005 Start Up Failure

SQL Server 2005 could fail to bring up due to various causes, there are several great blogs that...

Author: SQL Server Connectivity Date: 04/28/2006

Getting netmon sniff on local machine

To be able to do this, you need more than one network interface cards on the local machine.You can...

Author: SQL Server Connectivity Date: 04/24/2006

Checklist and tips for Connectivity Questions

In order to better assist troubleshooting connectivity related issues, the more specific you...

Author: SQL Server Connectivity Date: 04/21/2006

A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

The client error messages related to this post are the followings.For MDAC client, [DBNETLIB]General...

Author: SQL Server Connectivity Date: 04/11/2006

Restrict IP Address to prevent invalid login attack to SQL Server.

Recently, we in customer scenario, amount of attacks come through making connection to SQL Server...

Author: SQL Server Connectivity Date: 04/10/2006

Configure Aliases Programmatically Using WMI

In my previous post, I provided some sample C# code that allows you to configure SQL Server...

Author: SQL Server Connectivity Date: 04/08/2006

Troubleshoot Connectivity Issue with SQL Server Express 2005

Recently, we answered a lot of customer questions about how to make a successful connection to SQL...

Author: SQL Server Connectivity Date: 03/22/2006

Creating a SOAP sqlSession supported client application

SQL 2005 Native Web Services enables support for login environment settings through the use of SOAP...

Author: SQL Server Connectivity Date: 03/21/2006

Understand special TCP/IP property “Keep Alive” in SQL Server 2005

When open TCP/IP properties by following SQL Server Configuration Manager -> SQL Server 2005...

Author: SQL Server Connectivity Date: 03/08/2006

Next>