Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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