如果不指定Port，则无法连接到SQL实例。 [英] Can not connect to SQL Instance without specifying Port.

问题描述

这里有连接问题。


我们有一个未使用的默认实例（完全不活动并关闭） down），以及具有2台物理机和2台VM的SQL群集上的命名实例。此群集是主动/被动的。很长一段时间一切都很好。我们最近接到一个电话，没有指定端口，没有开发人员可以连接到实例。所以我们检查了TCP / IP是否已打开，我们检查了浏览器服务，确保所有必需的端口都已打开。所有看起来都没问题。


我们然后重新启动离线服务器，并对活动服务器进行故障转移，然后重启那个。


仍然没有运气。


我们检查了群集设置。我们正在使用动态端口，而Ipall是自动分配的56191.这是您必须指定的端口才能连接。我们在另一个盒子上有一个报告服务器，需要端口连接。


我们必须设置Kerberos以允许双跃点情况。我们注册了服务帐户和服务器，现在收到的错误表明服务器未知，错误消息列出了带端口的服务器名称。


当然我们在本地连接精细。我们认为SQL浏览器有问题，但不确定排除故障的最佳方法。


我们在Windows 2008 R2上使用MS SQL Server 2008。


有什么想法吗？谢谢你的帮助。

Hi,

Having a connectivity issue here.

We have a default instance which is not being used (totally inactive and shut down), and a named instance on a SQL Cluster with 2 physical machines, and 2 VMs. This cluster is active / passive. For a very long time everything was working fine. We recently got a call that none of the developers could connect to the instance without specifying the port. So we checked to see that TCP/IP was turned on, we checked the browser service, we made sure all the required ports were open. All looks okay.

We then reboot the offline server, and failed over the active server and then reboot that one.

Still no luck.

We checked the cluster setup. We are using dynamic ports and the Ipall was auto assigned 56191. That is the port you have to designate in order to connect. We have a reporting server on another box which requires the port to connect.

We had to set up Kerberos to allow for a double hop situation. We registered service accounts and servers and now are getting an error which states that the server is unknown, the error message lists the name of the server with the port.

Of course locally we connect fine. We think there is something wrong with the SQL browser but are not sure of the best way to troubleshoot.

We are using MS SQL Server 2008 on a Windows 2008 R2 box.

Any ideas? Thanks for your help.

推荐答案

如果我没有正确说出这个问题，我很抱歉。英语对我来说是一个绊脚石，所以我理解是否存在批评......或者是否有一些如此明显的东西，我错过了它，我可能无法保证回复，但任何帮助甚至批评都会受到赞赏。只要它指向另一个方向。我正在阅读大量材料而没有找到设置中可能出现的错误或任何可能表明突然变得需要端口号的原因。我没有设置群集或实例，但我发现在设置或防火墙和浏览器运行时没有任何突出显示。它没有在被动节点上运行，但是当它被故障转移时，集群会自动启动它。


如果你使用非标准端口，你总是必须在连接时指定端口？我以为sql浏览器仍然可以解析端口。我错了吗？


谢谢。

I am sorry if I did not word this issue properly. English is a stumbling block for me so I understand if there is criticism....or if there is something so obvious, and I have missed it, that I may not warrant a response, but any help even a criticism would be appreciated. As long as it points me in another direction. I am reading tons of material and not finding what could be wrong in the setup or anything that might indicate why a Port Number suddenly became required. I did not set up the cluster or instance but I see nothing that stands out as obvious in the setup, or on the firewall and the browser is running. It is not running on the passive node but when it fails over the cluster will automatically start that.

If you use a non-standard port do you always have to designate the port when connecting? I thought sql browser still could resolve the port. Am I wrong?

Thanks.

Vikki，


我可能是最苛刻的专家之一它涉及问题的清晰度和正确表达，我对你的问题的表现给我留下了深刻的印象，所以我不担心这个问题。你的问题超出了我有限的SQL经验，尽管我很害怕。我会为你做的是在专家区发布一些内容，引起人们对这个问题的关注。


我担心并非所有论坛都会提供及时的回复。该网站仅由志愿者组成，因此他们是免费的，只有在他们（大多数人已经忙碌的工作生活）时才可用。


无论如何，祝你好运： - ）

Vikki,

I am possibly one of the most demanding of experts when it comes to the clarity and the proper expression of questions, and I was impressed by how well your question was presented, so I wouldn''t worry on that score. Your question is beyond my limited SQL experience though I''m afraid. What I will do for you though, is post something in the Experts area drawing attention to this question.

I''m afraid not all forums offer prompt responses all the time. The site is staffed exclusively by volunteers and so they are free and available only when they are (most having busy working lives already).

Anyway, good luck with your question :-)

NeoPa，


非常感谢您的回复。我不是最好的沟通者，也不是我所知道的很多自学成才，所以我有时会想到我说的是正确的方法。我很感激你采取了额外的步骤。我对这个问题有很多看法，但截至目前还没有。


我现在正在使用网络监视器来跟踪数据包，到目前为止唯一的线索是数据包被不受欢迎。没有指定端口时我相信可能会有一些腐败。我发现了其他错误。我之前的DBA设置了一个维护计划但尚未运行并抛出Integration Services必须运行的错误，以便服务过去也能正常工作但现在却没有。


我今晚要尝试做一些诚信检查。


这是一个高流量的生产服务器，我非常担心它正在走向灾难。我们接到开发人员的额外电话，越来越多的工作失败了。备份也失败了所以这可能会成为那些有趣的夜晚之一。如果我们不能很快找到一些东西。好的回去工作。再次感谢。祝我成为一个奇迹。


Vikki

NeoPa,

Thanks very much for your response. I am not the best communicator and a lot of what I know I have self taught so I wonder sometimes if I am speaking the correct way. I appreciate you taking that extra step. I have had plenty of views on this one but no takers as of yet.

I am now using Network Monitor to trace the packets and the only clue so far is that the packet is "disreguarded" when no port is specified. I believe it is possible there may be some corruption. I am discovering other errors. The DBA before me setup a maintenance plan and that has not been running and throws an error that Integration Services must be running so that service used to be working also but now is not.

I am going to try and do some integrity checks tonight.

It is a high traffic production server and I am very concerned it is heading for disaster. We received additional phone calls from the developers that more and more jobs are failing. The backups are also failing so this could turn out to be one of those fun nights. If we can''t find something soon. Okay back to work. Thanks again. Wish me a miracle.

Vikki

这篇关于如果不指定Port，则无法连接到SQL实例。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！