How to connect to Azure VM SQL Server Analysis Service Instance using a Developer Computer
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.
This is how i have Azure environment is setup:
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.
Here is the Link to the blog that help with this.
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.
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"
or
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
- SQL Server random selection
- How to get a Table Object by table's name by sqlalchemy and query in it？
- How to create a deterministic uniqueidentifier (GUID) from an integer value
- ExecuteReader requires an open and available Connection. The connection's current state is Connecting
- Why must some stored procedures in MSSQL be called with `master..` prepended while other can be called without it?
- Insert sorted rows in another table using SQL
- How to split a comma-separated value to columns
- How to create a table from a pivot table?
- Convert a binary representation of a number stored as VARCHAR to INT
- What is the proper use of a clustered index?
- How to wait for MSSQL in Docker Compose?
- Resolving Poor Execution Plan in SQL Server with CLR Scalar Function
- Connect python-polars to SQL server (no support currently)
- T-SQL - stored procedure - "IF EXISTS" vs. "WHERE EXISTS"
- SSISDB package errs out, says variable does not exist
- error, string or binary data would be truncated when trying to insert
- Missing libtdsodbc.so in freetds-dev - MSSQL on Ubuntu
- Conditional update either column1 or column2 or column3
- Why do I keep getting Incorrect usage of const UDF in SSMS?
- Getting statistics on a temp table in SQL Server
- Generating self-closing XML tags for lists in SQL Server
- Where value in column containing comma delimited values
- SQL Server error on update command - "A severe error occurred on the current command"
- Invalid cast error on querying the database
- Dynamic SSRS LInk
- Table function in SQL Server with multiple parameters as an argument
- Is it possible to add index to a temp table? And what's the difference between create #t and declare @t
- How do I select the first row per group in an SQL Query?
- How do I find a disabled index on SQL server 2008
- SQL Server Object Explorer not showing a database