Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    56

    Unanswered: Restore db from different server via network

    Hello,
    I am trying to restore a SQL Server 2005 backup from another server via a job. The problem I have is that the Administrator password is different on each server and I get the following error.

    Operating system error 1326(Logon failure: unknown user name or bad password.).
    Msg 3013, Level 16, State 1, Line 8
    RESTORE DATABASE is terminating abnormally.


    Does anyone know if I can pass the credentials in with the script to authenticate to the other server?

    RESTORE DATABASE [Clinical]
    FROM DISK = @BACKUP_FILE


    Thanks
    Rebecca

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Is Windows Authentication an option for you?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •