Azure 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.

以 SSMS 連線To 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 > [物件總管] 中,按一下 [連線] > [分析服務] 。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:


    [驗證] 類型建議使用 [具 MFA 支援的 Active Directory - 通用] 。Authentication type, Active Directory - Universal with MFA support, is recommended.


    如果您使用 Microsoft 帳戶、Live ID、Yahoo、Gmail 等來登入,請將密碼欄位保留空白。If you sign in with a Microsoft Account, Live ID, Yahoo, Gmail, 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.

    具 MFA 支援的 Active Directory - 通用 請使用 非互動式或多重要素驗證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. 若要深入了解,請參閱 Deploy to Azure Analysis Services (部署至 Azure Analysis Services)。To 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. 若要深入了解,請參閱 Get data from Azure Analysis Services server (從 Azure Analysis Services 伺服器取得資料)。To learn more, see Get data from Azure Analysis Services server.