Building T-SQL Custom WSDL generator

We’ve gotten feedback from customers who have asked if it is possible to write a custom WSDL generator in T-SQL.  For those customers who do not wish to enable SQL CLR support, the following sample T-SQL SP can be used as a starting point for generating your own custom WSDL.  Please be advised that this…


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…


Troubleshooting Netlib that Comes with MDAC2.8 SP1/NET1.0, SNAC, SQL Server 2005 and NET 2.0 with ETW Tracing

Ever have issue with GNE (general network error)? Using ETW tracing can help. For feature description about ETW tracing for data access components, please refer to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/data_access_tracing.asp. Note that all commands used in this blog are shipped with OS by default since WINDOWS 2000.   [Steps]   1. Setup registry. C:tempreg add HKEY_LOCAL_MACHINESOFTWAREMicrosoftBidInterfaceLoader /v “:Path” /t…


Error Messages of SQL Server 2005 Start Up Failure

SQL Server 2005 could fail to bring up due to various causes, there are several great blogs that talk about different reason: http://blogs.msdn.com/sql_protocols/archive/2006/01/10/511330.aspx http://blogs.msdn.com/sql_protocols/archive/2005/10/31/487090.aspx http://blogs.msdn.com/sql_protocols/archive/2005/10/14/480848.aspx http://blogs.msdn.com/sql_protocols/archive/2006/03/09/546655.aspx In this blog, I am trying to summary all possible root cause and give resolution tips.   Part I – Read correct error info and find the exact error…


Getting netmon sniff on local machine

To be able to do this, you need more than one network interface cards on the local machine. You can do the same for one interface too (although it is a hack).   The key here is to ask for any loopback traffic (127.0.0.0) to go thru your new route (the gateway) and add a metric that…


Checklist and tips for Connectivity Questions

In order to better assist troubleshooting connectivity related issues, the more specific you describe the problems, the faster we can help you out. Please take a few minutes to answer the following questions and post them along with your specific repro steps.     Check out this blog site first, it may already have your questions answered….


A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

The client error messages related to this post are the followings. For MDAC client, [DBNETLIB]General network error. Check your network documentation. [DBNETLIB]ConnectionRead (recv()). For SNAC client, For SNAC client, “TCP Provider: An existing connection was forcibly closed by the remote host”. We found this issue after SQL Server 2005 Beta2 when w2k3sp1 (Windows 2003 server…