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
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 ==========
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
Install SQLSERVER2008_ASAMO10, SQLServer2005_ADOMD_x64 and SQLServer2008_ADOMD10_x64