SQL Protocols

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

SQL Server fails to start with ERRORLOG reporting “TDSSNIClient initialization failed with error 0x5, status code 0xXX”

I have seen this issue multiple times. So I post the problem and the solution here. 0x5 is...

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

Unable to connect to a SQL Server named instance on a cluster

We have been seeing several occurrences where users failed to connect to SQL Server named instance...

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

Understanding "login failed" (Error 18456) error messages in SQL Server 2005

In continuing with the theme of understanding error messages I'll discuss the "login failed"...

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

Understanding server-side protocol initialization error codes

With SQL Server 2005, a server-side protocol error will generally prevent the instance from...

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

Certificate for SQL Server 2005

Microsoft SQL Server 2005 can use Secure Sockets Layer (SSL) to encrypt data transmitted across a...

Author: SQL Server Connectivity Date: 12/30/2005

Troubleshoot Connectivity Issue in SQL Server 2005 - Part III

Part III – Connection Fail when SqlClient connects to Sql Server 2005When you connect to SQL...

Author: SQL Server Connectivity Date: 12/21/2005

VSS: SQL Server does not exist or access denied

I recently worked on three customer issues. In all those cases, customers were not able to backup...

Author: SQL Server Connectivity Date: 12/19/2005

Introduction to SQL 2005 Native XML Web Services November 30, 2005 webcast

On November 30, 2005, Srik presented in a webcast an introduction to SQL 2005 native xml web...

Author: SQL Server Connectivity Date: 12/16/2005

Unable to correct invalid SQL Server Network Configuration on clustered SQL Server causes clustered SQL Server fail to start “permanently”

Recently, we encountered an issue reported by a customer on a clustered SQL Server. What happens is...

Author: SQL Server Connectivity Date: 12/06/2005

Is Native Web Services (SOAP) supported in Express/Mobile/WinXP?

Some people have raised the question, "Is SOAP supported in SQL Express? How about SQL Mobile? I've...

Author: SQL Server Connectivity Date: 12/06/2005

Networking Protocols and SQL Server 2005 Virtual Server

SQL Server running on Windows Cluster Service is called SQL Server Virtual Server or SQL Server...

Author: SQL Server Connectivity Date: 12/05/2005

InfoPath: WSDLOperation: The parameters for element parameters in operation GetSystemDefinition could not be created.

There have been questions raised about how to make InfoPath work with SQL 2005 native web services....

Author: SQL Server Connectivity Date: 11/21/2005

SQL Express remote connections

Networking protocols are disabled by default in SQL Server Express. The error message you will get...

Author: SQL Server Connectivity Date: 11/14/2005

Encrypting connections in SQL Server 2005 & SQL Native Client with SSL

There are a few different encryption options for SQL Server 2005By default using SQL Native Client...

Author: SQL Server Connectivity Date: 11/10/2005

Connecting to SQL 2005 through SOAP Native Web Services using SQL user credentials from a different domain

Just as normal connections to SQL server support SQL user credentials, when logging into SQL 2005...

Author: SQL Server Connectivity Date: 11/02/2005

TDSSNIClient initialization failed with error 0xd, status code 0x36.

I've seen this problem posted a couple times on the MSDN forums so I'm including the problem and the...

Author: SQL Server Connectivity Date: 10/30/2005

Troubleshoot Connectivity Issue in SQL Server 2005 - Part II

Please visit http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx for troubleshooting...

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

Creation of SOAP(HTTP) SSL endpoint fails with error 0x80070494

Say you want to create an SSL endpoint for SOAP such as the following CREATE ENDPOINT...

Author: SQL Server Connectivity Date: 10/26/2005

SQL Server 2005 Connectivity Issue Troubleshoot - Part I

This post provides some tips to troubleshoot Sql Server connection problems based on various...

Author: SQL Server Connectivity Date: 10/21/2005

Configure and manage SQL Server 2005 from your application using WMI

Ever need to write your own scripts or applications to manage SQL Server 2005 instances? There are 3...

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

“Cannot generate SSPI context” error message, when connect to local SQL Server outside domain

The “Cannot generate SSPI context” issue is described by...

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

Unauthorized or AccessDenied exception when using SOAP Native Xml Web Services

One of the common problems people face when using SQL 2005 web services for the first time is the...

Author: SQL Server Connectivity Date: 10/18/2005

“Cannot Generate SSPI Context” error message, more comments for SQL Server

Users sometime see the “Cannot Generate SSPI Context” error message. A very good source...

Author: SQL Server Connectivity Date: 10/14/2005

Identifying system endpoints in SQL Server 2005

SQL Server 2005 introduces the concept of an ‘Endpoint’. Endpoints are objects that...

Author: SQL Server Connectivity Date: 10/13/2005

Sql Server 2005 fail to start up if there are spaces after tcp port

SYMPTOMS:When you try to start sql server 2005, it may fail and in the errorlog, it shows:Error:...

Author: SQL Server Connectivity Date: 10/13/2005

IPv6 and SQL Server 2005

Starting from SQL Server 2005 (Yukon), SQL Network Interface (SNI), the new SQL Server network...

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

Using Kerberos with SQL Server

Kerberos is a widely accepted network authentication protocol that is used to provide a highly...

Author: SQL Server Connectivity Date: 10/11/2005

Additional comments on how to enable channel encryption

In reference to a previous blog from Il-Sung Lee called "How to enable channel encryption"...

Author: SQL Server Connectivity Date: 10/11/2005

Valid SELECT statement resulting in empty DataSet

When using a Visual Studio 2005 application to retrieve a SELECT statement resultset through SQL...

Author: SQL Server Connectivity Date: 10/10/2005

How to Enable Channel Encryption

SQL Server 2005 offers the capability of channel encryption through the use of SSL (as did SQL...

Author: SQL Server Connectivity Date: 10/03/2005

SQL Server 2005 connectivity error messages

One of the more visible changes we made in connectivity space for SQL Server 2005 was enhancing...

Author: SQL Server Connectivity Date: 09/27/2005

SQL Server enumeration and Windows Firewall

Another customer issue using SQL Server enumeration. The customer was using the...

Author: SQL Server Connectivity Date: 09/23/2005

SQL server 2005 cluster failover considerations for HTTP SOAP services

When installing SQL server 2005, it is always a good practice to use a domain account as the SQL...

Author: SQL Server Connectivity Date: 09/23/2005

SQL Server enumeration returns SQL Express but not MSDE

I have recently came across the following problem: a customer was using EnumAvailableSqlServers()...

Author: SQL Server Connectivity Date: 09/23/2005

Highlights of SQL Server 2005 Communication Protocol Enhancements

Welcome to the new SQL Server Protocols team blog site. SQL Server 2005 (aka Yukon) will be released...

Author: SQL Server Connectivity Date: 09/22/2005

Welcome to the SQL Server Protocols blog site

Ever get a GNE? Ever wonder why SQL Discovery doesn't seem to be consistent? Ever get trapped by...

Author: SQL Server Connectivity Date: 09/22/2005

<Previous