menu
  • Register

Recent Badges

Popular Question peterlaw
Famous Question mphil
Notable Question peterlaw

the timeout period elapsed while attempting to consume the pre-login handshake acknowledgement

0 votes
36 views

Problem :

I am trying to use visual studio 2015 with sql server 2012 but facing following issue 

the timeout period elapsed while attempting to consume the pre-login handshake acknowledgement

6.9k points

1 Answer

0 votes

Solution :

I had encountered the similar issue in the past.
After doing research i found out the solution for your issue as follows.
It seems that there are too many subnets on our system i connected directly my IP with the servers IP with a specific port (1433) using the rule on the firewall and after that everything started working for me.
36.1k points

Related questions

0 votes
1 answer 10 views
10 views
one or more issues caused the setup to fail. please fix the issues and then retry setup
I want to find the solution of
asked Jul 24 James Martin 1.7k points
1 vote
1 answer 21 views
21 views
Unable to find manifest signing certificate in the certificate store.
Problem : I am unable to build my projects as I am facing below message: “Unable to find manifest signing certificate in the certificate store”. I have tried to run my Visual Studio as the Administrator and also I have tried to manually add my keys to ... Project Properties but above error is still appearing. I am unable to fix above error. Can someone guide me in fixing above error?
asked Apr 4 morrisBson 3.2k points
0 votes
1 answer 160 views
160 views
failed to launch the python process, please validate the path 'python'
Problem : I have just downloaded Python and Visual Studio & trying to test the debugging feature for a simple "Hello World" script but I'm receiving this error: failed to launch the python process, please validate the path 'python' Could someone please tell me how to fix this?
asked Oct 21, 2019 peterlaw 6.9k points
1 vote
1 answer 19 views
19 views
Invalid length parameter passed to the left or substring function.
Problem : I am very beginner to SQL Server. Currently I am trying to execute my SQL Server SUBSTRING query written by me but I am facing error. Please find below my query for your reference: select     substring(mytestcasename, 2, 5) val1,     substring(mytestcasename, ... 16, State 5, Line 1 Invalid length parameter passed to the LEFT or SUBSTRING function. Please guide me in fixing above error.
asked May 9 stewart 4k points
0 votes
1 answer 32 views
32 views
In sql server, execute the sp_columns command to list all the columns in a table?
Problem: I am little bit confused, which statement is true? In sql server, execute the sp_columns command to list all the columns in a table? True False
asked Feb 19 maddi86 5.4k points
Dark theme