1665912 - ERROR: "Login failed for user xyz. Reason: Failed to open the explicitly specified database" when restoring a database - BPC

• When restoring a database on a multi Server environment, OLAP database is not restored. The Window is standing still with the message "Creating OLAP database"

• On the database server, the following message is found in the MSSQL logs:
  
  Login failed for user xyz. Reason: Failed to open the explicitly specified database.
  
  
  The same message on OS level:
  Event Type: Failure Audit
  Event Source: MSSQLSERVER
  Event Category: Logon
  Event ID: 18456
  Date: 12/15/2011
  Time: 6:02:50 PM
  User: xyz
  Computer: servername
  Description:
  Login failed for user 'DOMAIN\xyz'. Reason: Failed to open the explicitly specified database. [CLIENT: 10.xxx.xxx.xxx]
  
  For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
  Data:
  0000: 18 48 00 00 0e 00 00 00 .H......
  0008: 0b 00 00 00 43 00 46 00 ....C.F.
  0010: 47 00 42 00 50 00 43 00 G.B.P.C.
  0018: 44 00 42 00 31 00 50 00 D.B.1.P.
  0020: 00 00 07 00 00 00 6d 00 ......m.
  0028: 61 00 73 00 74 00 65 00 a.s.t.e.
  0030: 72 00 00 00 r...
  
  

SAP Business Planning and Consolidation (BPC) version 7.0 for the Microsoft platform

BPC; 7.0; 7.5; Microsoft; Restore; Database; Server; MSSQL logs; "Login failed for user xyz. Reason: Failed to open the explicitly specified database";

, KBA , EPM-BPC-MS-SVM-BKP , Backup/Restore , Problem