Post reply

Connecting to SSAS 2005 Cube on a remote server using Excel 2003

  • August 28, 2008 at 6:36 am

    #189890

    Hello,

    I'm trying to connect to a deployed cube on a remote report server via Excel 2003. I can connect to the data warehouse on the report server so communication is possible but when I try and connect to the cube I get an error saying the service is busy or not started (which it is). I think it might be the firewall blocking the port but it might take weeks to open...helpful 😉

    I've tried changing the port SSAS listens to 8080 or 443 but once I make the change I cannot reconnect to SSAS on the report server unless I change it back to the default 0.

    Any advice would be greatly appreciated

    Thanks

    David

  • August 28, 2008 at 8:22 am

    #864425

    a couple of things to try:

    from the project that created and deployed the project originally, can you open the project file and connect and browse the cube through bids? if not, the cube may need to be reprocessed.

    if you can browse the cube locally (or on a dev machine), what user are you connecting to from the report server? does that user have access to the cube itself?

    if the user should have access, can you build a quick ssrs report against the cube and get data returned?

    it sounds as if either the cube is not available or there is a permissions issue

    hth

  • August 28, 2008 at 9:32 am

    #864514

    Hi,

    Thanks for the speedy reply:

    I can open the cube in bids on the dev machine and it looks to be fine. I've added the user (domain\user) to the roles and i'm using the same user on the other machine that is on the same domain, trying to connect with windows auth.

    Thanks

  • August 28, 2008 at 1:04 pm

    #864646

    is remote connections allowed?

    if you go to the server and navigate to the SQL Server 2005-->Configuration Tools-->SQL Surface Area Configuration and click on the link for Surface Area Configuration for Services and Connections, when you click the Analysis Services-->Remote Connections menu, is the option set for Local and Remote Connections?

    If it is and you are still having problems, here is a MS forum that might help out:

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=613519&SiteID=1

  • August 29, 2008 at 2:08 am

    #864872

    Hey,

    I look into it. Thanks for your help!

    Cheers

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

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