SQL Server 2008 R2到SQL Server 2012预登录握手错误。 [英] SQL Server 2008 R2 to SQL Server 2012 Pre - Login Handshake error.
问题描述
我有2个SQL Server，详细信息如下所示。新SQL Server用于托管旧SQL数据库服务器的数据库。
旧SQL Server
Windows Server 2008 R2
SQL Server 2008 R2
AD DS已安装&添加到名为'TheKingsburycmb.com'的域名
IP静态 - 192.168.1.180
默认网关 - 192.168.1.1
首选DNS - 192.168 .1.180
备用DNS - 203.115.0.46
我希望将此服务器的数据库数据传输到新的SQL Server。
新SQL Server
Windows Server 2012 Standard
SQL Server 2012 Standard
AD DS已安装&推广到以前的域名'TheKingsburycmb.com'
IP静态 - 192.168.1.181
默认网关 - 192.168.1.1
首选DNS - 192.168 .1.180
备用DNS - 203.115.0.46
我希望此服务器充当旧服务器的旧数据库的新SQL Server。
我所做的就是我连接到新SQL Server到它的SQL管理工作室'
对象资源管理器，它是一个成功，但当我尝试将OLD SQL Server添加到新的
---------------------------------------------- -----------------------------------------------
无法连接到OLDSQLServerName。
------------------------ ------
附加信息：
连接超时已过期。尝试使用
登录前握手确认时超时时间已过。这可能是因为登录前握手失败
或服务器无法及时回复。尝试
连接到此服务器所花费的时间是 - [Pre-Login] initialization = 22100;握手= 0; （Microsoft SQL
服务器，错误：-2）
---------------- -------------------------------------------------- ---------------------------
我启用了两个命名管道SQL Server配置管理器。但我无法理解限制使用对象资源管理器将OLD SQL Server添加到新SQL Server Management Studio的问题是什么？
你能帮助我吗？解决这个问题？
谢谢，
问候，
Chiranthaka
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
推荐答案
我得到了自己的解决方案它在下面说明。
问题是SQL Server 没有与 Windows Server进行通信 已安装 Active Directory域服务或简单AD DS 。
因为我未设置 SQL Server 首选 DNS服务器IP 为 AD DS安装的Windows服务器。因此，所需的SQL Server无法使用AD DS安装的服务器进行访问。
非常感谢你的努力。
谢谢，
问候，
Chiranthaka
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
这里已解决的主题 [ ^ ]
这篇关于SQL Server 2008 R2到SQL Server 2012预登录握手错误。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
