Problems deploying a ssas cube in Azure

• juanvg1972

  SSC Enthusiast

  Points: 184

  More actions

  November 5, 2016 at 6:12 pm

  #150543

  Hi,

  I am having problems deploying a ssas cube in Azure. I have designed a cube in SSDT.

  The structure of the cube is correct and I can access to the database placed in azure machine

  from my local laptop.My SSDT project is created in my local laptop. I have tried ti deploy to azure machine and

  get the following error;

  "The project could not be deployed to the 'mbitsql.westeurope.cloudapp.azure.com' server because of the following connectivity problems :

  A connection cannot be made. Ensure that the server is running.To verify or update the name of the target server, right-click

  on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server."

  These are my tests or checks:

  - The cube is correct generated, the error is in deployment

  - I can access to Azure sql server database succesfuly, the problem is with the analysis services.

  - I have checked the server name in the implementation propierties, I have tested with DNS name

  and with IP.

  - I have checked to access Analysis services from the ssms of Azure and I can access. I have

  checked that analysis services and sql browser services are running (both local account)

  - I have created security input rules ion azure to allow access to 2382 port

  I don't know where is the problem...

  There is something, that I don't understand, I have given an user/pass in the datasource to access

  to sql server azure database, but in the project there isn't a place to put the user/pass for SSAS.

  I don't understand this, because if you log from SSMS you always put a user/pass for both (sql server database and ssas)

  Any advice will be greatly appreciated.

  Thanks in advance

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  November 5, 2016 at 7:15 pm

  #1910783

  Can you connect to the SSAS Instance from SSMS (local, not on the VM)?

  As a generalized statement, i would think you'd either need federation and/or use of Azure AD, or alternatively utilize the msmdpump.dll and IIS on the VM and then pass a uid/pwd to the VM that exists on the VM.

  Steve.

• juanvg1972

  SSC Enthusiast

  Points: 184

  More actions

  November 6, 2016 at 1:59 am

  #1910787

  Thanks a lot Steve,

  Yes, I can connect to the SSAS Instance from SSMS (local, not on the VM)

  What is Azure AD?, Where can I find a explanation of use of msmdpump.dll?

  Thanks

  Juan

• juanvg1972

  SSC Enthusiast

  Points: 184

  More actions

  November 6, 2016 at 2:13 am

  #1910788

  Ok Steve, Azure AD is active directory...

  How do I know I have AD in my Azure machine?

  What steps do I have to do to give access to SSAS in AD

  Thanks again,