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...
Date: 10/13/2011
Annual SQL Connectivity Customer Survey
Greetings to the Developer community: Microsoft SQL Server team has been interacting on a regular...
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...
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...
Date: 10/12/2010
SQL Server "Login Failure" troubleshooter
Our colleagues over in the SQL Server Security team have developed an open tool for troubleshooting...
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...
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...
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...
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...
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...
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...
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...
Date: 09/19/2008
Configuring SQL Protocols through Windows PowerShell
Sometimes we are asked about the possibility of configuring SQL Server protocols through PowerShell....
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...
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...
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...
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...
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...
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...
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...
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...
Date: 04/07/2008
Service Principal Name (SPN)
Did you know that beginning with SQL Server 2008, support for service principal names (SPNs) has...
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...
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,...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 01/31/2007
Connection Alias
SQL Server client stack has a facility to let user define connection aliases. Connection Alias can...
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...
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...
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...
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...
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:...
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...
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...
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...
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...
Date: 04/24/2006
Checklist and tips for Connectivity Questions
In order to better assist troubleshooting connectivity related issues, the more specific you...
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...
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...
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...
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...
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...
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...
Date: 03/08/2006