连接到Azure托管的SQL Server Analysis Services服务器的表格实例 [英] Connecting to the Tabular Instance of an Azure-hosted SQL Server Analysis Services Server

问题描述

我已使用SQL Server 2016 Standard Edition映像设置了Azure虚拟机.我已经在计算机上安装了Analysis Services Tabular实例，并配置了端点，以便可以从本地计算机访问它.

I have set up an Azure Virtual Machine with a SQL Server 2016 Standard Edition image. I have installed an instance of Analysis Services Tabular on the machine and configured endpoints such that I can access it from my local machine.

我已经在此计算机上部署了SQL Server，SSAS多维和SSAS表格数据库.我可以连接到关系数据库，当我连接到Analysis Services时，可以使用IP地址或DNS名称，也可以连接到SSAS多维数据库.通常，我会在从Excel/Tableau/其他报告工具访问表格实例的服务器名称后添加\ tabular后缀以连接到表格实例.

I have deployed SQL Server, SSAS Multidimensional, and SSAS Tabular databases to this machine. I am able to connect to the relational databases, and when I connect to Analysis Services I either use the IP Address or DNS name, and I am able to connect to SSAS Multidimensional databases. Usually I would add the suffix \tabular to the Server name to connect to a Tabular Instance when accessing it from Excel/Tableau/other reporting tool.

但是，在服务器名称中使用\ tabular后缀时，出现错误"OLE DB提供程序中的错误.无法连接到重定向器.请确保该服务器上正在运行SQLBrowser服务器".我已经检查了虚拟机，并且该服务正在运行.我想知道\ tabular可能不是连接到Azure托管SQL Server的表格实例的正确语法.

However using the \tabular suffix in the Server Name I receive the error "Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser server is running on that server". I have checked the virtual machine, and I have that service running. I'm wondering if perhaps \tabular is not the correct syntax to connect to a tabular instance of an Azure-hosted SQL Server.

任何帮助或建议，将不胜感激.

Any help or advice would be appreciated.

推荐答案

我将RDP连接到服务器，然后在SSMS中连接到表格实例.右键单击服务器节点上的对象资源管理器，然后选择属性".转到常规"选项卡，然后将端口"属性更改为类似1234的名称，以便固定端口.重新启动SSAS表格服务.在VM上打开Windows防火墙应用程序，然后打开端口2382和1234.然后在Azure门户中编辑该VM的网络安全组，并为SQL Browser打开TCP端口2382，为SSAS Tabular打开1234(或选择的任何端口).现在，您可以连接到以下任一服务器名称:

I would RDP to the Server and connect in SSMS to the Tabular instance. Right click on Object Explorer on the Server Node and choose Properties. Go to the General tab and change the Port property to something like 1234 so the Port will be fixed. Restart the SSAS Tabular service. Open Windows Firewall app on the VM and open ports 2382 and 1234. Then edit the Network Security Group for that VM in the Azure portal and open tcp port 2382 for SQL Browser and 1234 (or whatever port you chose) for SSAS Tabular. Now you can connect to either of the following Server names:

服务器名\ TABULAR或者伺服器名称:1234

Servername\TABULAR or Servername:1234

有关此文档，可以在此处.

这篇关于连接到Azure托管的SQL Server Analysis Services服务器的表格实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！