SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for ASP.Net, SQL Server, Reporting Services, T-SQL, Windows, AWS, SAP HANA and ABAP


Error occurred during the pre-login handshake on SQL Server


You know Microsoft has recently released the CTP6 or the February CTP of MS SQL Server 2008. I have downloaded MS SQL2008 CTP 6 and installed two Microsoft SQL Server 2008 February CTP instances on two different servers.

While trying to connect from one database instance to the other SQL Server 2008 database instance using the Microsoft SQL Server Management Studio, I got the following error message :

Connect to Server
Cannot connect to KatmaiCTP6.
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

Although the error message is saying about "When connecting to SQL Server 2005", I got this message while connecting to a MS SQL Server 2008 instance.

I could solve this problem by using the SQL Server Configuration Manager. I opened the SQL Server Configuration Manager for the local database instance on the remote server. I drilled through the SQL Server Network Configuration and enabled TCP/IP protocol among the Protocols for MSSQLSERVER. TCP/IP is disabled by default so you may require to enable TCP/IP protocol for each of the SQL2008 database instances you install in order to make the database server available for remote connections using the TCP/IP protocol.

TCP/IP protocol is disabled by default on MS SQL SERVER 2008



SQL Server

SQL Server 2019 Installation
download SQL Server 2019
download SQL Server 2017
download SQL Server 2016
download SQL Server 2014
download SQL Server 2012
MacOS ve SQL Server 2019


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.