SQL Server 2008 R2 to SQL Server 2012 Pre - Login Handshake error.

Question

5.00/5 (1 vote)

See more:

SQL-Server-2008

, +

I have 2 SQL Servers, the details are as at the below. The New SQL Server is using to host the databases of the old SQL Database server.

OLD SQL Server

Windows Server 2008 R2
SQL Server 2008 R2
AD DS Installed & Added to a Domain named 'TheKingsburycmb.com'
IP Static - 192.168.1.180
Default Gateway - 192.168.1.1
Prefered DNS - 192.168.1.180
Alternate DNS - 203.115.0.46

I want this server's database's data to be transferred to the new SQL Server.

New SQL Server

Windows Server 2012 Standard
SQL Server 2012 Standard
AD DS Installed & promote to the previous domain 'TheKingsburycmb.com'
IP Static - 192.168.1.181
Default Gateway - 192.168.1.1
Prefered DNS - 192.168.1.180
Alternate DNS - 203.115.0.46

I want this server acts as the new SQL Server with old databases of the old server.

So what I have done is I connected to the New SQL Server to the its SQL Management Studios'
object explorer and it was a success but when I tried to add the OLD SQL Server to the New
SQL servers' Management Studio I got an error saying that as at the below!

---------------------------------------------------------------------------------------------
Cannot connect to OLDSQLServerName.

------------------------------
ADDITIONAL INFORMATION:

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=22100; handshake=0; (Microsoft SQL
Server, Error: -2)

---------------------------------------------------------------------------------------------

I have enabled Named Pipes of both SQL Server Configuration Managers. But I cannot understand what is the problem that is keeping restricting the adding the OLD SQL Server to the New SQL Servers Management Studio using Object Explorer?

Could you someone help me to solve this matter?

Thanks,
Regards,
Chiranthaka

Posted 21-Feb-14 18:32pm

Chiranthaka Sampath

Add a Solution

2 solutions

Solution 1

Here solved thread[^]

Posted 23-Feb-14 22:28pm

thatraja

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Chiranthaka Sampath · Accepted Answer · 2014-05-07T00:44:00

I've got the solution by my self & it is stated at the below.

The problem was that the SQL Server was not communicating with the Windows Server that has Active Directory Domain Service or simple AD DS was installed.

Because I have not set the SQL Servers preferred DNS server IP as the AD DS installed windows server. So the desired SQL Server is avoiding the access with the AD DS installed server.

Thanks guys however for your effort.

Thanks,
Regards,

Chiranthaka