Post reply

Problems deploying a ssas cube in Azure

  • 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

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

  • 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

  • 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,

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply