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

SAP Knowledge Base Article - Preview

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

Symptom

  • 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"

 restore_proc.jpg

  • 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...


Read more...

Environment

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

Product

SAP Business Planning and Consolidation 7.0, version for Microsoft

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.