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 https://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