SQL Server 2012 SSDT“无法将项目部署到......无法建立连接......"

2021-09-19 00:00:00 sql-server visual-studio-2012

我是 SQL Server 2012 的新手.这是我的情况.

I'm a newbie to SQL Server 2012. Here is my condition.

我有一个正在运行的 SQL Server 2012 Business Intelligence SP1.问题是我无法将项目从另一台计算机部署到我的 SSAS.

I have a running SQL Server 2012 Business Intelligence SP1. The problem is I cannot deploy a project to my SSAS from another computer.

错误是:

由于以下连接问题,项目无法部署到DATABASE-SERVER\MSSQLSERVER"服务器:无法连接到重定向器.确保SQL Browser"服务正在运行.要验证或更新目标服务器的名称,请在解决方案资源管理器中右键单击项目,选择项目属性,单击部署选项卡,然后输入服务器名称.

The project could not be deployed to the 'DATABASE-SERVER\MSSQLSERVER' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.

以下是我尝试过的事情:

The following is the things that I've tried:

  1. 在项目">属性">部署">目标服务器"上检查目标名称.

  1. Check the target name on Project > Properties > Deployment > Target server.

检查服务器服务 --> 所有 SQL Server 服务都在运行.

Check the server service --> all SQL Server services are running.

该项目可以从服务器部署.

The project can be deployed from server.

与服务器的连接正常

我可以从 SQL Server Management Studio 的另一台计算机连接到数据库引擎和分析服务.

I can connect to the Database Engine and Analysis Service from another computer from SQL Server Management Studio.

请帮我解决这个问题,这个问题我已经搜索了很多天了.

Please help me to fix this problem, I've been search for many days for this problem.

谢谢,抱歉我的英语不好.

Thank you, sorry for my bad english.

最好的问候,斯特拉.

推荐答案

我知道这是一个旧线程,但我遇到了同样的问题,我估计会有更多人遇到这个嗡嗡声.

I know this is an old thread, but I had the same issue and I reckon more will run into this buzz saw.

我的问题是SSAS的远程安装没有SSAS应用的入站防火墙规则;msmdsrv.exe.

My problem was that the remote installation of SSAS did not have an Inbound firewall rule for SSAS application; msmdsrv.exe.

分辨率:以管理员身份登录到运行 SSAS 的服务器启动 Windows 防火墙和高级安全添加入站规则,给它一个有意义的名字,比如 SQL Server - SSAS行动:允许连接在程序和服务选项卡上:对于此程序",请使用浏览并识别 msmdsrv.exe对于 SQL Server 2014,这里默认是:%ProgramFiles%\Microsoft SQL Server\MSAS12.SQLSVR14\OLAP\bin\msmdsrv.exe(2012年和2016年非常相似,数字不同)点击确定;您应该会看到一个带复选标记的绿点再次尝试您的项目;它应该连接,为我做.

Resolution: Log on to the server running SSAS as Administrator Launch Windows Firewall and advanced Security Add Inbound Rule, give it a meaningful name like SQL Server - SSAS Action: Allow the connection On Program and Services Tab: For 'This Program' use Browse and identify msmdsrv.exe For SQL Server 2014, it is by default here: %ProgramFiles%\Microsoft SQL Server\MSAS12.SQLSVR14\OLAP\bin\msmdsrv.exe (Very similar for 2012 and 2016, the numbers are different) Click OK; You should see a green dot with check mark Try your project again; It should connect, did for me.

注意:如果这也适用于您,请考虑返回入站规则并考虑出于安全原因添加连接限制.

NOTE: If this also work for you, consider going back to the Inbound Rule and consider adding connection restrictions for security reasons.

相关文章