SQL Server Alias'是否可以在网络上运行？ [英] Do SQL Server Alias' work across a network?

问题描述

我们有一台服务器进入报废状态。我们有多个应用程序可以访问该服务器。因此，我们不必手动更改所有这些应用程序以指向我想使用别名的新服务器。别名是旧服务器的名称。

We have a server entering end of life. We have multiple apps that hit that server. So that we don't have to manually change all of those apps to point to the new server I wanted to use an alias. The alias name being the name of the old server.

当我创建别名时，我可以从该服务器连接到SSMS中的别名。但是，我无法通过SSMS在另一台服务器上连接到该别名。为什么我不能通过网络连接到我给sql server的别名？我错过了什么？

When I create the alias I can connect to that alias name in SSMS from that server. But, I can't connect to that alias via SSMS on a different server. Why can I not connect to the alias name I gave my sql server over the network? What am I missing?

Mitch Taylor

Mitch Taylor

推荐答案

Hi Mitch Taylor，



你能分享详细的错误信息进行分析吗？ 

当你使用别名连接到远程机器上的实例，端口号（如果端口号不是1433）应该添加到连接字符串，如下面的屏幕截图。 

您是否在DNS下添加了别名，如下面的屏幕截图？请参阅
在SQL Server中配置别名。▼

请确保您已在防火墙中启用了TCP / IP协议和已打开的端口（默认为1433）。并检查SQL Server Browser服务正在运行。检查网络连接（Ping IP地址和服务器名称）。请参阅

从另一台计算机连接。 

 

祝你好运，

Cathy Ji

Hi Mitch Taylor,

Could you share the detailed error message for analysis? 
When you use alias connect to the instance on the remote machine, port number (if the port number is not 1433)should be added to connection string like below screenshot. 
Did you add the alias to DNS like below screenshot? Please refer to Configuring An Alias In SQL Server.
Please make sure you have enabled TCP/IP protocol and opened port (the default is 1433) in the Firewall. And check the SQL Server Browser Service is running. Check the network connection(Ping IP address and Server name).Please refer to Connecting from Another Computer. 
 
Best regards,
Cathy Ji

这篇关于SQL Server Alias'是否可以在网络上运行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！