Coding Villa Forum
Home Newsletter Contact us FAQs
Articles Forums Members Chat Rooms Blogs News
FAQs
Recent discussions
How to set different background colors for list view's rows? Answered (2 replies)
Query to get all duplicate records from SQL Table. Answered (1 replies)
Method to get Mp3 files from assets folder in Android Answered (1 replies)
How to add a drop down menu in android app? Answered (1 replies)
Set image as wallpaper fits for all screen sizes Answered (1 replies)
Best practice to share data among activities in Android? Answered (1 replies)
How to get maximum id of a field from a table SqLite DB in android? Answered (1 replies)
Best method to compare elements in a string with DB fields before insertion Answered (1 replies)
How to Get Text/Value from Textbox and Print it in Android app Answered (1 replies)
Get Camera streaming in android application Answered (1 replies)
Advertisements

A connection was successfully established with the server, error occurred during pre-login handshake

Iram Online 7/27/2012 2:47:21 PM

Hello Friends!

I have a problem with SQL Server 2005. Every time I try to connect my SQL server 2005, connection established successfully with the server. However, then an error occurred during the pre-login handshake. Following is the detailed error i am receiving.

(provider: SSL Provider, error: 0 - The wait operation timed out.)
A connection was successfully established with the server, but then an error occurred during the pre-login handshake.

Please friends help me in resolving that issue. Waiting for your guidance friends

Thanks
Share with Friends

Advertisements

Answer

Saad Online 8/3/2012 3:13:32 PM

Hi Iram,
There is a possibility that your TCP/IP protocol is not enabled for clients. Without TCP/IP protocol you can not access the sql server from other clients. Following is the method to enable the protocol.

Go to the Start-->Programs-->SQL Server--> Configuration Tools-->SQL Configuration Manager.

Expand the SQL Network Configuration and click on the PROTOCOLS node

Right click on TCP/IP and open up the PROPERTIES panel

Select the IP ADDRESS tab

Make sure the values for the IP ADDRESS fields are correct and match the system it is running on. If its not the same then provide the valid ip through which you want to access sql server from client machine.

Restart the service, and you should be back in business, I was.

After that enable the TCP/IP protocol under SQL Native Client protocol node

Make sure you fill in the TCP PORT, even if you are using the default 1433.

Also make sure that Forced Encryption in instance properties is set to NO.
Share with Friends

Post reply

 

Enter This Code
Captcha
 

Subscribe

Email me when people reply


Subscribe to the


Articles | Forums | Blogs | News | Members | Chat

Home

Our Websites

Our Products

Policy

Copyright 2010-2012 INTELLISOFT solutions