我在使用微软分析服务 2008 时遇到了问题,它无法识别我创建的主机别名(尽管数据库引擎可以识别它)。
Here s the deal: we have some code that looks for an analysis services server called PRODUCTION. For testing purposes we would like to have PRODUCTION point to localhost. Under SQL Server 2000 and 2005, we accomplished that by:
adding an entry on my local machine in the C:Windowssystem32driversetchosts file to read: 127.0.0.1 PRODUCTION
在 Sql Server 配置管理器中启用 TCP/IP
- Creating an Alias for PRODUCTION in the Sql Server Configuration Manager
这对于数据库引擎非常有效。我可以将SQL Server Management Studio连接到服务器“生产”,并且它会显示出我的本地机器。我可以ping“生产”,它可以正常工作:
Pinging PRODUCTION [127.0.0.1] with 32 bytes of data:
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128 Reply from 127.0.0.1: bytes=32 time<1ms TTL=128 Reply from 127.0.0.1: bytes=32 time<1ms TTL=128 Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Ping statistics for 127.0.0.1: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
这对于分析服务无法生效--就像找不到服务器一样。在管理工具中,我可以正常连接“localhost”作为分析服务服务器,但是当我使用“PRODUCTION”作为服务器时,我从“连接到服务器”对话框中获得以下错误:
"A connection cannot be made. Ensure that the server is running ... Unable to read data from the transport connection: an existing connection was forcibly closed by the remote host".
这个错误与我只是输入一个我知道不存在于服务器上的主机所得到的错误略有不同:
"A connection cannot be made. Ensure that the server is running ... No such host is known"
这让我觉得某些东西被禁用了。或者我需要像上面的步骤2和3一样启用其他东西吗?
他们是否更改了Analysis Services 2008,以不使用DNS来解析名称?