Skip to Content
author's profile photo Former Member
Former Member

Installation fails W.Server 2008, Sql 2008 R2

Hi,

I need help ASAP please !!

Im trying to install BPC 75 SP03 MS version, in Windows Server 2008, SQL 2008 R2 but I cant manage to get the installation done, an error is shown up and I cant go further even though I applied 2 different workarounds.

Please suggest something

Error:

15/09/2011 12:57:55 p.m. OlapVersion : : OLAP_VERSION_2005

15/09/2011 12:57:55 p.m. GetTimeMembers : End

15/09/2011 12:57:56 p.m. Validate base member of Time dimension. : Succeed

15/09/2011 12:57:56 p.m. Get information of ApShel from SQL. : Succeed

15/09/2011 12:57:56 p.m. Check Insight : Insight disabled.

15/09/2011 12:58:00 p.m. Connect to Olap server(BPCDEMO) :

15/09/2011 12:58:01 p.m. Step 2 : -- Create Olap DB.

15/09/2011 12:58:01 p.m. Step 3 : -- Create DataSource.

15/09/2011 12:58:02 p.m. Step 3 : -- Create DataSource View.

15/09/2011 12:58:02 p.m. Step 4 : -- Create Dimensions.

15/09/2011 12:58:11 p.m. -- C_ACCT : Fail

15/09/2011 12:58:11 p.m. CreateNewOlapDB : True - Message:OLE DB error: OLE DB or ODBC error.

Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'AppDef', Name of 'AppDef'.

Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'ApShell', Name of 'C_ACCT' was being processed.

Server: The operation has been cancelled.

15/09/2011 12:58:11 p.m. Create ApShell : ========== END ==========

Workaround 1.

Open up SQL Management Studio

2. Go to Security > Logins > NT AUTHORITYLOCAL SERVICE

3. Right click > Properties

4. In the User Mapping section tick ApShell

5. In the bottom section of the screen, tick db_datareader

Workaround 2.

Install SQLSERVER2008_ASAMO10, SQLServer2005_ADOMD_x64 and SQLServer2008_ADOMD10_x64

Please help

Velázquez

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Sep 19, 2011 at 03:07 PM

    Hi there,

    Support for SQL Server 2008 R2 only became available in BPC MS 7.5 SP04

    See [Note 1512045 - Planning and Consolidation 75M SP04 Central Note|https://service.sap.com/sap/support/notes/1512045]

    Can you access and process the cubes/dims in SSAS?

    Thanks,

    John

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 30, 2011 at 02:08 PM

    Hi Velázquez

    This error is because the OLAP server is unable to connect to the SQL Server. The account running the OLAP service doesn't have sufficient rights to connect to the SQL Server. You can change the AppDef to use credentials which have access to the SQL Server AppSet Database.

    This should resolve your problem.

    Kind Regards

    Daniel

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.