Showing posts with label olap. Show all posts
Showing posts with label olap. Show all posts

Tuesday, February 14, 2012

Cannot connect to OLAP database using Credential Stored in report server

Hi guys,

I'm having problem regarding connecting to OLAP Database when I use the Credential stored in the Report Server. When I tried using the Credential stored in the Report Server connecting to OLTP database, It works fine.

Below is the error I'm geting when connecting to OLAP Database.

  • An error has occurred during report processing. (rsProcessingAborted)
  • Cannot create a connection to data source 'DS_Project88_OLAP'. (rsErrorOpeningConnection)
  • For more information about this error navigate to the report server on the local server machine, or enable remote errors
  • There are several reasons why the connection could fail. I recommend to check the report server logfile for more information on the exception from the data provider, or enable remote errors (see: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=230593&SiteID=1) to turn on detailed errors for all users.

    -- Robert

  • Sunday, February 12, 2012

    cannot connect to analysis server

    I have installed sql 2k and analysis service 2k including sp3a on my PC with XP professional. When I try to connect to the olap service from the olap manager I get the "cannot open connection to the analysis server". Does any one has a clue on a solution?RTFM ... :D

    You'll need to setup an ODBC - Connection to a msdb-file (foodmart sample) before you can use analysis manager for further proceedings ...

    Do a quick browse through the "getting started" docs offered in the analysis manager result pane - (you'll not need 60minutes as is noted there to read them, just find the first step - "setting up an odbc dsn") -
    from then on, you'll be able to connect to AS.

    IMHO, a kind of really strange desgin , I just stumbled into this myself ...

    Friday, February 10, 2012

    Cannot Connect to Analysis Services Olap Server

    When attempting to connect to a Microsoft Analysis Server from the Crystal Report (v10), the following error message appears:

    "The connection could not be established. The logon attempt failed".

    I am using Windows XP Pro.

    Why is this happening? At the Crystal Report I am using the wizard to create a new report and specifically I am using at the Server options the 1st one (where I specify the Server Name, User Name & Password). Also the 'Server Connection' is 'Direct to the OLAP Server'.

    Both the Crystal Report & Analysis Services are running under the same PC, thus there are no network connectivity issues.

    I also tried to connect using the Excel to the Analysis Services (where I used the same UserId and Password, to the one I tried with Crystal Reports) and the connection was succesful.

    I also checked the Firewall settins, and its ok as the Crystal Report is under the Excpetions.

    Why then can't I connect?

    There are quite a few questions related to troubleshooting connectivity problems.

    First you need to see if you have problem connecting to Analysis Services.
    See if this post is going to help you: http://www.sqljunkies.com/WebLog/edwardm/

    Edward.
    --
    This posting is provided "AS IS" with no warranties, and confers no rights.

    Cannot Connect to Analysis Server-not a member of OLAP Admin

    I have set up the the Analysis Service to log on as DOMAIN\administrator.
    I have added DOMAIN\administrator as a member of OLAP Adminitration
    I initially logged in as DOMAIN\administrator.
    Upon trying to connect in Analysis Server, I get the error messge Cannot
    connect to SERVER registry or you are not a member of the OLAP
    AdministratorGroup
    What gives? How do I resolve this?
    Are you running the latest service pack for Analysis Services?
    Kevin E.
    "Diane" <Diane@.discussions.microsoft.com> wrote in message
    news:B2888652-78F9-4F32-88B2-F21C03A48A65@.microsoft.com...
    >I have set up the the Analysis Service to log on as DOMAIN\administrator.
    > I have added DOMAIN\administrator as a member of OLAP Adminitration
    > I initially logged in as DOMAIN\administrator.
    > Upon trying to connect in Analysis Server, I get the error messge Cannot
    > connect to SERVER registry or you are not a member of the OLAP
    > AdministratorGroup
    > What gives? How do I resolve this?
    |||Yes, I am.
    "Diane" wrote:

    > I have set up the the Analysis Service to log on as DOMAIN\administrator.
    > I have added DOMAIN\administrator as a member of OLAP Adminitration
    > I initially logged in as DOMAIN\administrator.
    > Upon trying to connect in Analysis Server, I get the error messge Cannot
    > connect to SERVER registry or you are not a member of the OLAP
    > AdministratorGroup
    > What gives? How do I resolve this?
    |||We had the same problem on some of our installations. Seems like after we
    rebooted and then tried to connect it worked fine. Might of had something to
    do with MSSQLServerOLAPService not being started until after reboot. Just a
    thought.
    Kevin
    "Diane" <Diane@.discussions.microsoft.com> wrote in message
    news:904C6394-D5AE-4BC4-8A45-39B58AA742BD@.microsoft.com...[vbcol=seagreen]
    > Yes, I am.
    > "Diane" wrote:

    cannot connect to analysis server

    I have installed sql 2k and analysis service 2k including sp3a on my PC with XP professional. When I try to connect to the olap service from the olap manager I get the "cannot open connection to the analysis server". Does any one has a clue on a solution?RTFM ... :D

    You'll need to setup an ODBC - Connection to a msdb-file (foodmart sample) before you can use analysis manager for further proceedings ...

    Do a quick browse through the "getting started" docs offered in the analysis manager result pane - (you'll not need 60minutes as is noted there to read them, just find the first step - "setting up an odbc dsn") -
    from then on, you'll be able to connect to AS.

    IMHO, a kind of really strange desgin , I just stumbled into this myself ...