locked
Error making Cubes from Project 2007 and SQL 2008 RRS feed

  • Question

  • I have this systems:

    ·         SQL Server 2008 Enterprise

    ·         SQL Native Client 10.0

    ·         SQL Backward Compatibility 2005

    ·         SQL XMO 2005

    and I am guetting this error message:

    Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server SHAREPOINT. Error: Cannot connect to Analysis Services version '10.0.2531.0'.

     

    Standard Information:PSI Entry Point:

    Project User: ARKIX\mossinstall

    Correlation Id: 12eefd87-0dad-4b9b-b4c7-798173f9d3d0

    PWA Site URL: http://sharepoint/PWA

    SSP Name: SSP2

    PSError: CBSASConnectionFailure (17003)

    Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error: Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=SHAREPOINT ASDBName=CubAX ASExtraNetAddress=SHAREPOINT RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=05/07/2010 17:10:21 ToDate=05/07/2010 17:10:21 HighPriority=True

     

    Project Server Analysis Cube

    We have followed these steps http://technet.microsoft.com/en-us/library/dd285466(office.12).aspx

    The strange point is that some Cubes works perfect, and these one in particular does not.

    We checked all it says here http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/d7ddcb5c-88d0-4bd9-aee8-b93ca12c99a6

    And all is correct. However the error message is there any way.

    Can anyone has another solution?

    Thanks a lot, Lina

    Wednesday, May 26, 2010 8:08 PM

Answers

All replies

  • Hi Lina,
     
     
    When you say some cubes work perfectly, are these cubes also built by Project Server (via other instances), or are you referring to cubes that have been built by another application?
     
    Regards,  Ben.

    I have this systems:

    ·         SQL Server 2008 Enterprise

    ·         SQL Native Client 10.0

    ·         SQL Backward Compatibility 2005

    ·         SQL XMO 2005

    and I am guetting this error message:

    Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server SHAREPOINT. Error: Cannot connect to Analysis Services version '10.0.2531.0'.

     

    Standard Information:PSI Entry Point:

    Project User: ARKIX\mossinstall

    Correlation Id: 12eefd87-0dad-4b9b-b4c7-798173f9d3d0

    PWA Site URL: http://sharepoint/PWA

    SSP Name: SSP2

    PSError: CBSASConnectionFailure (17003)

    Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error: Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=SHAREPOINT ASDBName=CubAX ASExtraNetAddress=SHAREPOINT RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=05/07/2010 17:10:21 ToDate=05/07/2010 17:10:21 HighPriority=True

     

    Project Server Analysis Cube

    We have followed these steps http://technet.microsoft.com/en-us/library/dd285466(office.12).aspx

    The strange point is that some Cubes works perfect, and these one in particular does not.

    We checked all it says here http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/d7ddcb5c-88d0-4bd9-aee8-b93ca12c99a6

    And all is correct. However the error message is there any way.

    Can anyone has another solution?

    Thanks a lot, Lina


    Ben Howard [MVP] http://appleparkltd.spaces.live.com/
    Thursday, May 27, 2010 8:34 AM
  • Bizarre, I had this on site today, and I'd blogged it back in June 09.  Basically you need to use the Native client from the SQL Server 2008 Feature Pack October 2008.  http://appleparkltd.spaces.live.com/?_c11_BlogPart_BlogPart=blogview&_c=BlogPart&partqs=amonth%3d6%26ayear%3d2009 
    "Ben_Howard" wrote in message news:0027c45d-3e6f-4bfe-af4f-4ab68daf1368...
    Hi Lina,
     
     
    When you say some cubes work perfectly, are these cubes also built by Project Server (via other instances), or are you referring to cubes that have been built by another application?
     
    Regards,  Ben.

    I have this systems:

    ·         SQL Server 2008 Enterprise

    ·         SQL Native Client 10.0

    ·         SQL Backward Compatibility 2005

    ·         SQL XMO 2005

    and I am guetting this error message:

    Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server SHAREPOINT. Error: Cannot connect to Analysis Services version '10.0.2531.0'.

     

    Standard Information:PSI Entry Point:

    Project User: ARKIX\mossinstall

    Correlation Id: 12eefd87-0dad-4b9b-b4c7-798173f9d3d0

    PWA Site URL: http://sharepoint/PWA

    SSP Name: SSP2

    PSError: CBSASConnectionFailure (17003)

    Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error: Setting UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=SHAREPOINT ASDBName=CubAX ASExtraNetAddress=SHAREPOINT RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=05/07/2010 17:10:21 ToDate=05/07/2010 17:10:21 HighPriority=True

     

    Project Server Analysis Cube

    We have followed these steps http://technet.microsoft.com/en-us/library/dd285466(office.12).aspx

    The strange point is that some Cubes works perfect, and these one in particular does not.

    We checked all it says here http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/d7ddcb5c-88d0-4bd9-aee8-b93ca12c99a6

    And all is correct. However the error message is there any way.

    Can anyone has another solution?

    Thanks a lot, Lina


    Ben Howard [MVP] http://appleparkltd.spaces.live.com/

    Ben Howard [MVP] http://appleparkltd.spaces.live.com/
    Friday, May 28, 2010 2:55 PM