Click here to Skip to main content
15,311,944 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
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

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
   
   

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900