SQL Server 2005 connectivity error messages

One of the more visible changes we made in connectivity space for SQL Server 2005 was enhancing error messages reported to the user in case of connection failures.  I have seen several cases over the last several months, and in this post I would like to list some of them with the root cause that…


Troubleshoot Connectivity Issue in SQL Server 2005 – Part III

Part III – Connection Fail when SqlClient connects to Sql Server 2005 When you connect to SQL Server 2005 either using “SQL Server Managment Studio” or any application compiled with .NET Framework 2.0, you are using SqlClient provider(Access data from within a CLR database object by using the .NET Framework Data Provider for SQL Server.)…


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…


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…


Troubleshoot Connectivity Issue with SQL Server Express 2005

Recently, we answered a lot of customer questions about how to make a successful connection to SQL Express 2005 through MSDN forum and our blogs. Here, I collect basic info about it and a brief guide of making local and remote connection to SQL Server Express 2005. Part I – Quick overview with SQL Server 2005…


SQL Server 2005 Remote Connectivity Issue TroubleShoot

With shipping SQL Server 2005, we heard from customer feedback about suffering make successful remote connection against SQL 2k5, plus, if running SQL Server on XP/WIN2K3/VISTA behind firewall, such problem occurs more frequently and harder for customer to get clue of behind reason. I. Background of remote connectivity issue. The reason we saw the issue…


SQL Linked Server Query failed with “Login failed for user …”

SQL Server 2005: “Login failed for user ‘NT AUTHORITYANONYMOUS LOGON’”. SQL Server 2000: “Login failed for user “(null)”. Reason: Not associated with a trusted SQL Server connection”.   The errors listed above is very typical when deploy linked server with delegation. They actually are thrown by the linked server and pass by middle server to…