SQL Protocols
learn.microsoft.com/en-us/archive/blogs/sql_protocols
Topics from the Microsoft SQL Server Protocols team - Netlibs, TDS, SQL Browser, etc...
- Posts
- 85 from 22 Sep 2005 to 13 Oct 2011
- Posting
- archived, read-only
- Kind
- company blog
- Feed
- https://learn.microsoft.com/en-us/archive/blogs/sql_protocols/feed.xml
2011 2
2010 4
2009 4
- Selectively using secure connection to SQL Server
- We would like to hear your opinion...
- Connection from a Windows Service could be blocked by firewall even if firewall is disabled
- Understanding the error “An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.”
2008 12
- TCP listening ports and ENDPOINT ports behavior
- Understanding “Data Source=(local)” in SQL Server Connection Strings
- Configuring SQL Protocols through Windows PowerShell
- Connection failure because of mismatched TDS version
- Troubleshooting SQL Server Cluster Installations
- Connectivity troubleshooting in SQL Server 2008 with the Connectivity Ring Buffer
- Understanding the error message: “Login failed for user ''. The user is not associated with a trusted SQL Server connection.”
- Steps to troubleshoot SQL connectivity issues
- Could not connect to X64 named instance
- Understanding “Connection forcibly closed by remote host” Errors Caused by TOE/Chimney
- Why Browser is installed under 90shared directory rathar than 100Shared?
- Service Principal Name (SPN)
2007 12
- TCP Provider: No connection could be made because the target machine actively refused it
- Login failed for user <xx>, Msg 18456, Level 14, State 1
- SSL Cipher Suites used with SQL Server
- Install a self-signed test certificate that can be loaded by SQL Server automatically
- Connecting to SQL Server 2005 on Vista and Longhorn
- Named Pipes Provider, error: 40 - Could not open a connection to SQL Server (Microsoft SQL Server, Error: XXX)
- SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
- Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
- Building a WebMethod FORMAT=NONE Stored Procedure
- TDSSNIClient initialization failed with error 0x50, status code 0x50
- Connection Alias
- "Cannot Generate SSPI Context" error message, Poisoned DNS
2006 19
- Understanding Kerberos and NTLM authentication in SQL Server Connections
- Building T-SQL Custom WSDL generator
- SQL Server 2005 Remote Connectivity Issue TroubleShoot
- SQL Linked Server Query failed with “Login failed for user …”
- Troubleshooting Netlib that Comes with MDAC2.8 SP1/NET1.0, SNAC, SQL Server 2005 and NET 2.0 with ETW Tracing
- "No process is on the other end of pipe" caused by bad certificate
- Error Messages of SQL Server 2005 Start Up Failure
- Getting netmon sniff on local machine
- Checklist and tips for Connectivity Questions
- 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
- Restrict IP Address to prevent invalid login attack to SQL Server.
- Configure Aliases Programmatically Using WMI
- Troubleshoot Connectivity Issue with SQL Server Express 2005
- Creating a SOAP sqlSession supported client application
- Understand special TCP/IP property “Keep Alive” in SQL Server 2005
- SQL Server fails to start with ERRORLOG reporting “TDSSNIClient initialization failed with error 0x5, status code 0xXX”
- Unable to connect to a SQL Server named instance on a cluster
- Understanding "login failed" (Error 18456) error messages in SQL Server 2005
- Understanding server-side protocol initialization error codes
2005 32
- Certificate for SQL Server 2005
- Troubleshoot Connectivity Issue in SQL Server 2005 - Part III
- VSS: SQL Server does not exist or access denied
- Introduction to SQL 2005 Native XML Web Services November 30, 2005 webcast
- Unable to correct invalid SQL Server Network Configuration on clustered SQL Server causes clustered SQL Server fail to start “permanently”
- Is Native Web Services (SOAP) supported in Express/Mobile/WinXP?
- Networking Protocols and SQL Server 2005 Virtual Server
- InfoPath: WSDLOperation: The parameters for element parameters in operation GetSystemDefinition could not be created.
- SQL Express remote connections
- Encrypting connections in SQL Server 2005 & SQL Native Client with SSL
- Connecting to SQL 2005 through SOAP Native Web Services using SQL user credentials from a different domain
- TDSSNIClient initialization failed with error 0xd, status code 0x36.
- Troubleshoot Connectivity Issue in SQL Server 2005 - Part II
- Creation of SOAP(HTTP) SSL endpoint fails with error 0x80070494
- SQL Server 2005 Connectivity Issue Troubleshoot - Part I
- Configure and manage SQL Server 2005 from your application using WMI
- “Cannot generate SSPI context” error message, when connect to local SQL Server outside domain
- Unauthorized or AccessDenied exception when using SOAP Native Xml Web Services
- “Cannot Generate SSPI Context” error message, more comments for SQL Server
- Identifying system endpoints in SQL Server 2005
- Sql Server 2005 fail to start up if there are spaces after tcp port
- IPv6 and SQL Server 2005
- Using Kerberos with SQL Server
- Additional comments on how to enable channel encryption
- Valid SELECT statement resulting in empty DataSet
- How to Enable Channel Encryption
- SQL Server 2005 connectivity error messages
- SQL Server enumeration and Windows Firewall
- SQL server 2005 cluster failover considerations for HTTP SOAP services
- SQL Server enumeration returns SQL Express but not MSDE
- Highlights of SQL Server 2005 Communication Protocol Enhancements
- Welcome to the SQL Server Protocols blog site