Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    18

    Unanswered: Analysis Services: Deploy a cube

    I'm making my first attempt at creating a cube using Analysis Services based on my exisiting datamart. Datasource, views, and dimensions have been defined. But comes deploying the cube, it's giving the error saying "A connection cannot be made. Ensure that the server is running." The Deploy Target server and database are the same where my datamart is. Or, maybe I don't know what I'm doing.

    Would appreciate any suggestion for my enlightenment. Thanks

  2. #2
    Join Date
    Jun 2007
    Posts
    1
    JodJim,

    I am assuming you properly specified target server name. Next steps:
    1. Make sure that SQL Server Analysis Services service is running. It is not the same service as SQL service. You can do this in Adminitrator Tools ->Services. This is most likely cause why you cannot deploy
    2. Make sure you are member of administrators local group on SSAS server. This will give you admin right required to deploy database.

    If that does not work:
    Start SQL Server Management Studio and connect to analysis services. Any problems? Any messages?

    Vidas Matelis
    http://www.ssas-info.com
    http://www.ssas-info.com/VidasMatelisBlog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •