Skip to Content
0
Former Member
Sep 19, 2011 at 02:04 PM

Installation fails W.Server 2008, Sql 2008 R2

26 Views

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