syscomments

RocketScientist's Miscellaneous Ramblings
posts - 76, comments - 354, trackbacks - 3

An actual SQL post for a change

This is a pretty interesting blog from Microsoft about how networking works in SQL Server:
http://blogs.msdn.com/sql_protocols/default.aspx

I found them when I did a google search for a sql server error 18456.  They're encoding the actual problem in the STATE information:

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Of course, when you fail to log in using the SQL Server Management Studio it doesn't display state information, so this information is absolutely accurate and completely useless for trying to diagnose connection issues from the studio.

Print | posted on Monday, February 04, 2008 4:23 PM |

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET