管理 Analysis ServicesManage Analysis Services

在 Azure 中创建 Analysis Services 服务器后,可能会有一些需要立即执行或在稍后操作期间执行的管理任务。Once you've created an Analysis Services server in Azure, there may be some administration and management tasks you need to perform right away or sometime down the road. 例如,处理刷新数据、控制谁有权访问服务器上的模型,或者监视服务器的运行状况。For example, run processing to the refresh data, control who can access the models on your server, or monitor your server's health. 某些管理任务仅可在 Azure 门户中执行,而其他一些可在 SQL Server Management Studio (SSMS) 中执行,还有部分在两者中均可执行。Some management tasks can only be performed in Azure portal, others in SQL Server Management Studio (SSMS), and some tasks can be done in either.

Azure 门户Azure portal

Azure 门户中,可创建和删除服务器、监控服务器资源、更改大小和管理有权访问服务器的人员。Azure portal is where you can create and delete servers, monitor server resources, change size, and manage who has access to your servers. 如果遇到问题,可提交支持请求。If you're having some problems, you can also submit a support request.

在 Azure 中获取服务器名称

SQL Server Management StudioSQL Server Management Studio

就像连接到自身组织中的服务器实例一样,在 Azure 中连接到服务器。Connecting to your server in Azure is just like connecting to a server instance in your own organization. 可在 SSMS 中执行许多相同的任务,例如处理数据或创建处理脚本、管理角色和使用 PowerShell。From SSMS, you can perform many of the same tasks such as process data or create a processing script, manage roles, and use PowerShell.

SQL Server Management Studio

下载并安装 SSMSDownload and install SSMS

若要获取全部最新功能,并在连接至 Azure Analysis Services 服务器时享受最流畅的体验,请确保使用最新版本的 SSMS。To get all the latest features, and the smoothest experience when connecting to your Azure Analysis Services server, be sure you're using the latest version of SSMS.

下载 SQL Server Management StudioDownload SQL Server Management Studio.

连接 SSMSTo connect with SSMS

使用 SSMS 时,在首次连接到服务器之前,需确保用户名已包含在 Analysis Services 管理员组中。When using SSMS, before connecting to your server the first time, make sure your username is included in the Analysis Services Admins group. 有关详细信息,请参阅本文后面的服务器管理员和数据库用户To learn more, see Server administrators and database users later in this article.

  1. 在连接之前,需要获取服务器名称。Before you connect, you need to get the server name. Azure 门户 中,单击“服务器”>“概述” > “服务器名称” ,并复制服务器名称。In Azure portal > server > Overview > Server name , copy the server name.

    在 Azure 中获取服务器名称

  2. 在 SSMS >“对象资源管理器” 中,单击“连接” > “Analysis Services” 。In SSMS > Object Explorer , click Connect > Analysis Services .

  3. 在“连接到服务器” 对话框中,粘贴服务器名称,并在“身份验证” 中选择以下身份验证类型之一:In the Connect to Server dialog box, paste in the server name, then in Authentication , choose one of the following authentication types:

    备注

    建议选择“Active Directory - 通用且具有 MFA 支持”身份验证类型。 Authentication type, Active Directory - Universal with MFA support , is recommended.

    备注

    如果使用 Microsoft 帐户、Live ID、Yahoo 等登录,请将密码字段留空。If you sign in with a Microsoft Account, Live ID, Yahoo, etc., leave the password field blank. 单击“连接”后,系统将提示你输入密码。You are prompted for a password after clicking Connect.

    选择“Windows 身份验证” ,以使用 Windows 域\用户名和密码凭据。Windows Authentication to use your Windows domain\username and password credentials.

    Active Directory 密码身份验证 ,其使用组织帐户。Active Directory Password Authentication to use an organizational account. 例如,从未加入域的计算机进行连接时。For example, when connecting from a non-domain joined computer.

    选择“Active Directory - 通用且具有 MFA 支持” ,以使用非交互式或多重身份验证Active Directory - Universal with MFA support to use non-interactive or multi-factor authentication.

    在 SSMS 中连接

服务器管理员和数据库用户Server administrators and database users

Azure Analysis Services 中存在两种类型的用户,即服务器管理员和数据库用户。In Azure Analysis Services, there are two types of users, server administrators and database users. 这两种类型的用户必须存在于 Azure Active Directory 中,且必须由组织电子邮件地址或 UPN 指定。Both types of users must be in your Azure Active Directory and must be specified by organizational email address or UPN. 若要了解详细信息,请参阅身份验证和用户权限To learn more, see Authentication and user permissions.

排查连接问题Troubleshooting connection problems

若在使用 SSMS 进行连接时遇到问题,则可能需要清除登录缓存。When connecting using SSMS, if you run into problems, you may need to clear the login cache. 光盘中不缓存任何内容。若要清除缓存,请关闭并重启连接进程。Nothing is cached to disc. To clear the cache, close and restart the connect process.

后续步骤Next steps

如果尚未将表格模型部署到新服务器,现在正是一个好时机。If you haven't already deployed a tabular model to your new server, now is a good time. 有关详细信息,请参阅部署到 Azure Analysis ServicesTo learn more, see Deploy to Azure Analysis Services.

如果已将模型部署到服务器,可使用客户端或浏览器连接到该模型。If you've deployed a model to your server, you're ready to connect to it using a client or browser. 有关详细信息,请参阅从 Azure Analysis Services 获取数据To learn more, see Get data from Azure Analysis Services server.