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 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 error messsages in your SQL Server ERRORLOG: 2005-10-30 15:35:44.79 Server      Error: 17182, Severity: 16, State: 1.2005-10-30 15:35:44.79 Server     …


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 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 to simulate the connection string in your application and quick troubleshoot if your application uses ODBC provider and use Query Analyzer (isqlw.exe) in SQL Server…


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 SOAP_ssl_endpoint    STATE = STARTED   AS HTTP (   SITE = ‘localhost’,    PATH = ‘/MySoapPath’,    AUTHENTICATION = (INTEGRATED ),    PORTS = ( SSL ),   SSL_PORT=443) FOR SOAP (   …………); And the creation fails with the error message Msg 7807, Level 16, State 1, Line 1An error (‘0x80070494’) occurred while…


SQL Server 2005 Connectivity Issue Troubleshoot – Part I

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 topic.   First Part – Troubleshoot SNAC connect to SQL Server 2005 Second Part – Troubleshoot MDAC connect to…


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 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 protocol on the server side.WMI (Windows Management…


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

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 cases, customers report this issue as “I can connect to my local SQL Server, but once I…


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 requirement of specifying credentials in the SOAP request.  Unlike .Net Framework web services, where the server may not require credentials, SQL 2005 has a strict rule that credentials must be specified. If your client application was…


“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 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. Here, I talk about one extreme situation: SQL server was running under Local System and was shutdown accidentally. The user then decides to…


Identifying system endpoints in SQL Server 2005

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 Pipe, VIA) that accept TDS connections. An additional endpoint is created for the dedicated administrator connection…


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: 17182, Severity: 16, State: 1.TDSSNIClient initialization failed with error 0xd, status code 0x10 Error: 17826, Severity: 18, State: 3.Could not start the network library because of an internal error in the network library. To determine the…