1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

System Databases restoring

Discussion in 'Microsoft SQL Server' started by Gipsy, Nov 27, 2012.

  1. Gipsy

    Gipsy New Member

    Joined:
    Aug 20, 2012
    Messages:
    3
    Likes Received:
    0
    Hello,

    i'm testing the TDP 6.X for SQL.

    How can I restore the system databases (master)??

    -------

    1. Starting the SQL in Single Mode (sqlservr.exe -m)
    2. Starting the TDP Console
    3. Select the master database
    4. Restoring with Replace (true).

    Error: ACO5424E Could not connect to SQL server; SQL server returned: Failed to connect to server SQLSERVER. Login failed for user 'Domain\Administrator'. Reason: Server is in single user mode. Only one administrator can connect at this time.

    The Connection in the TDP is configured for Windows Authentication

    => http://publib.boulder.ibm.com/infoc...ex.jsp?topic=/com.ibm.itsmfd.doc/dpsql151.htm

    --

    What have I forgotten? Are there any tutorials or videos?

    Can you help me?

    Thanks
     
    Last edited: Nov 27, 2012
  2.  
  3. domino

    domino Senior Member

    Joined:
    Nov 16, 2005
    Messages:
    718
    Likes Received:
    32
    Occupation:
    System Engineer
    Location:
    Germany
    Any member of the computer's local Administrators group can connect to the instance of SQL Server as a member of the sysadmin fixed server role.
     
  4. Gipsy

    Gipsy New Member

    Joined:
    Aug 20, 2012
    Messages:
    3
    Likes Received:
    0
    Hello domino,

    thank you for your answer!

    What you mean? The user 'administrator' is in the local Administrator-Group and fixed sysadmin user.

    When i try with SQL Authentication => 'sa', then is the same error.

    --

    When i try it, sql-single-mode prompt (cmd) show this:

    2012-11-27 23:24:20.71 Logon Login failed for user 'Domain\Administrator'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: <local machine>]

    OR

    2012-11-27 23:25:39.46 Logon Error: 18461, Severity: 14, State: 1.
    2012-11-27 23:25:39.46 Logon Login failed for user 'sa'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: IP-Address]

    ---

    Can you help me? Do you need more information?
     
  5. davegeeit

    davegeeit New Member

    Joined:
    Nov 22, 2012
    Messages:
    2
    Likes Received:
    0
    [FONT=Calibri, serif]RecoveryFIX for SQL Database Recovery retrieves all data stored within SQL server .MDF files such as tables, triggers, views, stored procedures with damaged unique keys, primary keys and foreign keys. Deleted files are also successfully recovered and saved in a separate batch file for further use.
    [/FONT]http://www.repairsqlserver.net[FONT=Calibri, serif]

    Thanks
    [/FONT]
     
  6. opermty

    opermty Senior Member

    Joined:
    Jan 23, 2010
    Messages:
    219
    Likes Received:
    10
    Occupation:
    Ingeniero de Soporte
    Location:
    San Nicolas de los Garza NL

Share This Page