Category: SQL Server

26 Jul 2016 21:45

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	3

How to fixe this Issue in Sql Server- connection timeout expired.

Hi

I have Installed Sql Server 2014 Successfully. But I am facing following error. But
I am following this url

But i canot Fixed this any one guide me.

This is Error
========

Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=18106; handshake=14314;
(Microsoft SQL Server, Error: -2)

#767312

26 Jul 2016 23:47

Joined:	15/12/2015
Level:	Gold
Points:	1308

Points:	3

Hi,
Enable the firewall settings on server. Make sure TCP port 1433 is open.
Enable both Named Pipes and TCP/IP(IPv4 and IPv6) on the SQL Server Configuration Manager as follows:
StartMenu-> AllProgram-> Microsoft Sql Server 2014-> Sql Server 2014 Configuration Manager-> Sql native Client 11.0 Configuration-> Client Protocols

#767314

26 Jul 2016 23:58

Joined:	05/06/2009
Level:	Gold
Points:	10245

Points:	3

Are you trying to login using query analyser?
Did you installed Express edition? or other editions?

1. Check the authentication mode
Open up SQL Server Management Studio and connect to your database server.
Right Click The Database Server and click Properties.
Set the Server Authentication to SQL Server and Windows Authentication Mode.
2. Turn off firewall and check
3. If it is express edition. Enable both Named Pipes and TCP/IP(IPv4 and IPv6)

By Nathan
Direction is important than speed

How to fixe this Issue in Sql Server- connection timeout expired.

About dotnetspider.com

Quick Links

General

Services