SQL Server“."别名不工作 [英] SQL Server "." Alias Not Working

问题描述

我添加了一个别名."它应该指向我的本地(命名)实例.SQL2008".但是当我尝试连接到."时，它会超时.

I've added an alias of "." which should point to my local (named) instance, ".SQL2008". But when I try to connect to ".", it times out.

是我遗漏了什么还是不允许这样做?

Am I missing something or is this not allowed?

我尝试过的别名不起作用:

(设置为 32 位和 64 位，我也尝试过将端口留空.)

(Set for both 32 and 64-bit, I've also tried leaving the port blank.)

推荐答案

如果您正在创建 TCP/IP 别名，您需要确保SQL Server Browser"服务正在运行.同时检查服务器和客户端是否启用了 TCP/IP 协议.

If you are creating TCP/IP aliases you need to ensure the "SQL Server Browser" service is running. As well as checking the TCP/IP protocol is enabled for both server and client.

在SQL Server 服务 节点下的Sql Server 配置管理器 中，右键单击SQL Server 浏览器 并将启动模式设置为自动.如果您不打算重新启动，您还需要手动启动服务.

In Sql Server configuration Manager under the SQL Server Services node right click the SQL Server Browser and set the Start Mode to Automatic. If you are not going to do a reboot you will also need to Start the service manually.

SQL Server Browser 服务负责告诉客户端使用哪个端口.请参阅 http://technet.microsoft.com/en-us/library/ms181087(v=sql.105).aspx了解更多详情.

The SQL Server Browser service is responsible for telling the client which port to use. See http://technet.microsoft.com/en-us/library/ms181087(v=sql.105).aspx for more details.

这篇关于SQL Server“."别名不工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！