Welcome to MSDN Blogs Sign in | Join | Help

SQL Protocols

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

May 2007 - Posts

Named Pipes Provider, error: 40 - Could not open a connection to SQL Server (Microsoft SQL Server, Error: XXX)
This error message is the most frequent error message when connecting to SQL Server. You see this error message when you use SqlClient. In SNAC, the error message is slightly differently as follows: C:\>osql -E -Syourserver [SQL Native Client]Named Read More...
SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
Users often see this error message when connection to a SQL Server and don't know where to start to solve the problem. In most forums, people says this is because remote connection is not enabled on the server. This is not exactly correct. Actually, this Read More...
Connecting to SQL Server from a workgroup using Windows Authentication
When SQL Server and/or client application is not in a domain, users usually could not use Windows Authentication. In this case, SQL Authentication is recommended. However, there are some corner cases you can use Windows Authentication from a workgroup Read More...
Page view tracker