问题描述
我们有一台服务器进入报废状态。我们有多个应用程序可以访问该服务器。因此,我们不必手动更改所有这些应用程序以指向我想使用别名的新服务器。别名是旧服务器的名称。
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
推荐答案
这篇关于SQL Server Alias'是否可以在网络上运行?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!