Welcome to MSDN Blogs Sign in | Join | Help

SQL Protocols

Topics from the Microsoft SQL Server Protocols team - Netlibs, TDS, SQL Browser, etc...

March 2006 - Posts

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 Read More...
Posted: Thursday, March 23, 2006 3:39 AM by SQL Protocols | 88 Comments
Creating a SOAP sqlSession supported client application
SQL 2005 Native Web Services enables support for login environment settings through the use of SOAP Headers. The set of environment settings include: initialLanugage initialDatabase applicationName clientInterface clientPID hostName networkID enableNotifications Read More...
Posted: Tuesday, March 21, 2006 7:40 PM by SQL Protocols | 1 Comments
Understand special TCP/IP property “Keep Alive” in SQL Server 2005
When open TCP/IP properties by following SQL Server Configuration Manager -> SQL Server 2005 Network Configuration ->Protocols -> TCP/IP, you will notice there is new added property named “Keep Alive”, which is not available in SQL Server 2000. Read More...
Posted: Thursday, March 09, 2006 4:51 AM by SQL Protocols | 16 Comments
SQL Server fails to start with ERRORLOG reporting “TDSSNIClient initialization failed with error 0x5, status code 0xXX”
I have seen this issue multiple times. So I post the problem and the solution here. 0x5 is ERROR_ACCESS_DENIED, the windows error code for “Access is denied”. A typical SQL Server ERRORLOG looks like, 2006-03-06 10:48:27.99 Server Server is listening Read More...
Posted: Thursday, March 09, 2006 12:17 AM by SQL Protocols | 5 Comments
Page view tracker