SQL Server Performance

Errors on my cube processing

Discussion in 'SQL Server 2008 Analysis Services' started by eobiki10, Dec 8, 2010.

  1. eobiki10 New Member

    Please I need someone to tell me how to rectify these errors during my cube processing.
    1. OLE DB error: OLE DB or ODBC error: login failed for user 'NT AUTHORITYNETWORK SERVICE.; 28000; cannot open database "AdventureWorksDW2008R2" requested by the login. The login failed.

    2. Errors in the high-level relational engine. A connection could not be made to the Data source with the Data source ID of 'AdventureWorksDW2008R2', Name of 'AdventureWorksDW2008R2'.

    3. Errors in the OLAP storage engine: An error occured while the dimension with the ID of 'Dim Date', Name of 'Dim Date' was being processed.

    4.Errors in the OLAP storage engine: An error occured while the 'Date key' attribute of the 'Dim Date' dimension from the 'SSAS Project' database was being processed.

    5. Internal error: The operation terminated unsuccessfully.

    6. Server: The operation has been cancelled.
  2. satya Moderator

    Welcome to the forums.
    Check what account is used to start the SQL Analysis Services service?
    Also make sure the data source view is able to connect the underlying dimensions from BIDS tool.

Share This Page