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...

Another customer issue using SQL Server enumeration. The customer was using the EnumAvailableSqlServers() API from SQL Server 2005 SMO. The local box had three instances of SQL Server installed: (a) a default instance of SQL Server 2000, (b) a named...

When installing SQL server 2005, it is always a good practice to use a domain account as the SQL service account and to ensure that such account does not have full administration rights on the local computer. There are some implications in doing this...

I have recently came across the following problem: a customer was using EnumAvailableSqlServers() API from SQL Server 2005 SMO to enumerate installed SQL Servers. The customer's box contained both an installation of SQL Server 2005 SQL Express edition...

Welcome to the new SQL Server Protocols team blog site. SQL Server 2005 (aka Yukon) will be released with an impressive list of new features and capabilities and I'd like to highlight some of the enhancements to the connectivity/protocols layer of SQL...

Ever get a GNE? Ever wonder why SQL Discovery doesn't seem to be consistent? Ever get trapped by Window's firewall? Confused about VIA? Then, this is the blog site for you to watch. This blog is run by the SQL Server protocols component team. This...