Sign In
SQL Protocols
Topics from the Microsoft SQL Server Protocols team - Netlibs, TDS, SQL Browser, etc...
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
10055
ADO.NET
annoucement
Connection String
connectivity
data access
Firewall
hang
JDBC
Login
Longhorn
ODBC
PHP
PowerShell
socket
SQL Browser
SQL Server
SQL Server 2005
SQL Server Cluster
SQLConnection
Vista
Windows 7
Windows Server 2008 R2
Winsock
WSAENOBUFS
Archive
Archives
October 2011
(1)
August 2011
(1)
October 2010
(2)
August 2010
(1)
April 2010
(1)
January 2010
(1)
October 2009
(2)
September 2009
(1)
March 2009
(1)
November 2008
(1)
September 2008
(1)
August 2008
(1)
July 2008
(1)
June 2008
(1)
May 2008
(2)
April 2008
(5)
July 2007
(1)
June 2007
(4)
May 2007
(2)
March 2007
(1)
February 2007
(2)
January 2007
(2)
December 2006
(1)
November 2006
(1)
September 2006
(1)
August 2006
(2)
July 2006
(1)
April 2006
(6)
March 2006
(4)
February 2006
(2)
January 2006
(1)
December 2005
(7)
November 2005
(4)
October 2005
(15)
September 2005
(6)
October, 2005
MSDN Blogs
>
SQL Protocols
>
October, 2005
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
SQL Protocols
TDSSNIClient initialization failed with error 0xd, status code 0x36.
Posted
over 7 years ago
by
SQL Server Connectivity
103
Comments
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...
SQL Protocols
Troubleshoot Connectivity Issue in SQL Server 2005 - Part II
Posted
over 7 years ago
by
SQL Server Connectivity
98
Comments
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...
SQL Protocols
Creation of SOAP(HTTP) SSL endpoint fails with error 0x80070494
Posted
over 7 years ago
by
SQL Server Connectivity
8
Comments
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 ( ...
SQL Protocols
SQL Server 2005 Connectivity Issue Troubleshoot - Part I
Posted
over 7 years ago
by
SQL Server Connectivity
142
Comments
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...
SQL Protocols
Configure and manage SQL Server 2005 from your application using WMI
Posted
over 7 years ago
by
SQL Server Connectivity
4
Comments
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...
SQL Protocols
“Cannot generate SSPI context” error message, when connect to local SQL Server outside domain
Posted
over 7 years ago
by
SQL Server Connectivity
64
Comments
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...
SQL Protocols
Unauthorized or AccessDenied exception when using SOAP Native Xml Web Services
Posted
over 7 years ago
by
SQL Server Connectivity
10
Comments
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...
SQL Protocols
“Cannot Generate SSPI Context” error message, more comments for SQL Server
Posted
over 7 years ago
by
SQL Server Connectivity
30
Comments
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...
SQL Protocols
Identifying system endpoints in SQL Server 2005
Posted
over 7 years ago
by
SQL Server Connectivity
3
Comments
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...
SQL Protocols
Sql Server 2005 fail to start up if there are spaces after tcp port
Posted
over 7 years ago
by
SQL Server Connectivity
7
Comments
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...
SQL Protocols
IPv6 and SQL Server 2005
Posted
over 7 years ago
by
SQL Server Connectivity
3
Comments
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...
SQL Protocols
Using Kerberos with SQL Server
Posted
over 7 years ago
by
SQL Server Connectivity
46
Comments
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...
SQL Protocols
Additional comments on how to enable channel encryption
Posted
over 7 years ago
by
SQL Server Connectivity
0
Comments
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...
SQL Protocols
Valid SELECT statement resulting in empty DataSet
Posted
over 7 years ago
by
SQL Server Connectivity
6
Comments
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...
SQL Protocols
How to Enable Channel Encryption
Posted
over 7 years ago
by
SQL Server Connectivity
2
Comments
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...
Page 1 of 1 (15 items)