問題描述

我需要一種方法來從家里的開發人員計算機連接到 Microsoft Azure 虛擬機上的 SQL Server 分析服務默認實例.我知道我只能使用 Windows 身份驗證連接到分析服務，我一直無法弄清楚.但是，我設法使用 SQL Server 身份驗證連接到 SQL Server 數據庫引擎.

I need a way to connect to an SQL Server Analysis Service default instance on Microsoft Azure Virtual Machine from my developer computer at home. I understand that i can only connect to Analysis Service using Windows Authentication and i haven't been able to figure that out. However, i managed to connect to the SQL Server Database Engine using SQL Server Authentication.

這是我設置 Azure 環境的方式:

This is how i have Azure environment is setup:

為了使用 SQL Server 身份驗證設置與 SQL Server 數據庫引擎的連接，我在 Microsoft Azure 管理門戶中創建了一個端點，端口 1433 用于私有，一個隨機端口用于公共.我在端口 2383 上對 Analysis Service 執行了相同的過程，但仍然沒有運氣.如果沒有這種連接，我認為我將無法部署 BI Cube.

To setup my connection to SQL Server Database Engine using SQL Server Authentication, i created an Endpoint in Microsoft Azure Management Portal with port 1433 for private, and a random port for public. I have done the same process for Analysis Service on port 2383 but still no luck. Without this connection, i don't think i will be able to deploy BI Cubes.

這里是有助于解決此問題的博客.

如何設置我的虛擬機，以便能夠使用 SQL Management Studio 和/或 Visual Studio 2013 連接到 Analysis Service?任何幫助或建議將不勝感激.

How can i setup my Virtual Machine so that i will be able to connect to Analysis Service using SQL Management Studio and or Visual Studio 2013? Any help or suggestions will be appreciated.

推薦答案

因為 Analysis Services 使用 AD 帳戶，因為您的開發人員計算機與運行 Analysis Services 的 VM 不在同一域中，您將需要使用 runas 工具使用/netonly 參數運行 Visual Studio 或 SQL Mgmt Studio 等應用程序，以便您可以正確進行身份驗證.

Because Analysis Services works with AD accounts, as your developer machine is not on the same domain as the VM running Analysis Services, you will need to use the runas tool with the /netonly parameter to run the applications such as Visual Studio or SQL Mgmt Studio so that you can be authenticated correctly.

當我需要這樣做時，我使用如下命令在桌面上創建一個快捷方式:

When I need to do this, I create a shortcut on my desktop with the command as follows:

runas /netonly /user:mydomain\myusername "C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\devenv.exe"

或

runas /netonly /user:mydomain\myusername "C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Ssms.exe"

當您運行快捷方式時，您會看到一個命令提示符，詢問您正在運行的帳戶的密碼，然后程序將打開.

When you run the short cut you will get a command prompt that will ask you for the password for the account you are running as and then the program will open.

從那里你可以正常使用它

From there you can use it normally

這篇關于如何使用開發人員計算機連接到 Azure VM SQL Server 分析服務實例的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！