October 2005 - Posts
I've seen this problem posted a couple times on the MSDN forums so I'm including the problem and the solution here. The MSDN SQL Server Data Access Forum is available at: http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=87 . If you see the following
Read More...
Please visit http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx for troubleshooting connection problems when SNAC(SQL Native Client) connect to SQL Server 2005. Part II – Connection Fail when MDAC connects to SQL Server 2005 Use osql.exe
Read More...
Say you want to create an SSL endpoint for SOAP such as the following CREATE ENDPOINT SOAP_ssl_endpoint STATE = STARTED AS HTTP ( SITE = 'localhost', PATH = '/MySoapPath', AUTHENTICATION = (INTEGRATED ), PORTS = ( SSL ), SSL_PORT=443 ) FOR SOAP ( …………
Read More...
This post provides some tips to troubleshoot Sql Server connection problems based on various displayed error messages. And, I will describe connection problems according to different client stack: SNAC/MDAC/SQLClient. Thus, there are 3 parts for this
Read More...
Ever need to write your own scripts or applications to manage SQL Server 2005 instances? There are 3 sets of APIs you can use to do this: SMO, SQL-DMO, or WMI. I will introduce WMI here, and give some sample code in C# which will enable/disable a certain
Read More...
The “Cannot generate SSPI context” issue is described by http://support.microsoft.com/?id=811889 in general. In this post I will discuss one daunting case of “Cannot generate SSPI context” error message when failing to connect to SQL server. In most related
Read More...
One of the common problems people face when using SQL 2005 web services for the first time is the requirement of specifying credentials in the SOAP request. Unlike .Net Framework web services, where the server may not require credentials, SQL 2005 has
Read More...
Users sometime see the “Cannot Generate SSPI Context” error message. A very good source for troubleshooting the error is http://support.microsoft.com/default.aspx?scid=kb;en-us;811889 . You can also find good information at Using Kerberos with SQL Server
Read More...
SQL Server 2005 introduces the concept of an ‘Endpoint’. Endpoints are objects that represent a communication point between the server and a client. SQL Server automatically creates an endpoint for each of the four protocols (TCP/IP, Shared Memory, Named
Read More...
SYMPTOMS: When you try to start sql server 2005, it may fail and in the errorlog, it shows: Error: 17182, Severity: 16, State: 1. TDSSNIClient initialization failed with error 0xd, status code 0x10 Error: 17826, Severity: 18, State: 3. Could not start
Read More...
Starting from SQL Server 2005 (Yukon), SQL Network Interface (SNI), the new SQL Server network library, supports internet protocol version 6, IPv6, through Windows IPv6 stack. As you might already know, currently, many Window platforms can be configured
Read More...
Kerberos is a widely accepted network authentication protocol that is used to provide a highly secure method to authenticate users. Reliance is placed upon a trusted third party called the Key Distribution Center (KDC) to facilitate the generation and
Read More...
In reference to a previous blog from Il-Sung Lee called "How to enable channel encryption" ( https://blogs.msdn.com/sql_protocols/archive/2005/10/04/476705.aspx ), I have one more comment to add. There is a special case with a client forcing encryption
Read More...
When using a Visual Studio 2005 application to retrieve a SELECT statement resultset through SQL 2005 native web services, the resultset is de-serialized from the wire format into a DataSet object. It is possible that even though the resultset is completely
Read More...
SQL Server 2005 offers the capability of channel encryption through the use of SSL (as did SQL Server 2000). The instructions for doing so are well documented in the BOL but I'll briefly descirbe what's entailed here. The first thing you need to do is
Read More...
