DB Restore gives LOGON error and lock user in Active Directory

[Dito74]

I'm trying to restore a Database to a different server (not source where I got the backup from!) and I get logon failure:
If I don't eneter anything, I get my account locked;
If I use the "Arcserve System Account", that account gets locked;
If I use the "SA" (using the SQL Agent), I get the same error:
[from Job Log]
BrightStor ARCserve Backup -- Restore
E8605
Failed to start restore. (DBNAME=6/08/04 4:00 PM, EC=Windows Error 1326: Logon failure: unknown user name or bad password. )

Totals For................... Job
Total Session(s)............. 0
Total Database(s)............ 0
Total Skip(s)................ 0
Total Size (Disk)............ 0 KB
Total Size (DB).............. 0 KB
Total Size (Media)........... 0 KB
Elapsed Time................. 0s
Average Throughput........... 0 KB/min
Total Error(s)/Warning(s).... 1/0

Restore Operation Failed.

------------------------------------------------------------
[from Activity Log]

Type Date Job Session Message
----------------------------------------------------------------------------------------------------
Information 08/03/2004 09:30:00 AM [JOBQUEUE]: Status changed from Active to Done. [Job No: 3] [Description: ]
Information 08/03/2004 09:29:40 AM 102 Restore Operation Failed.
Information 08/03/2004 09:29:40 AM 102 Number of Error(s)/Warning(s): 1/0
Information 08/03/2004 09:29:40 AM 102 Average Throughput: 0 KB/min
Information 08/03/2004 09:29:40 AM 102 Elapsed Time: 0s
Information 08/03/2004 09:29:40 AM 102 0 Database(s)/Transaction Log(s) (0 KB) Restored to Disk.
Information 08/03/2004 09:29:40 AM 102 0 Session(s) Found on Media.
Information 08/03/2004 09:29:40 AM 102 ** Summary for Job **
E8605 08/03/2004 09:29:37 AM 102 Failed to start restore. (DBNAME=6/08/04 4:00 PM, EC=Windows Error 1326: Logon failure: unknown user name or bad password. )
Information 08/03/2004 09:29:37 AM 102 Connected with SQL Server database agent at \\DESTINATIONSERVERNAME.
Information 08/03/2004 09:28:58 AM 102 Start Restore Operation. (QUEUE=1, JOB=3)
Information 08/03/2004 09:28:58 AM 102 Run Restore Job Now.
Information 08/03/2004 09:28:53 AM [JOBQUEUE]: Added [Job No: 3] [Description: ]
Information 08/03/2004 09:25:47 AM [JOBQUEUE]: Deleted [Job No: 3] [Description: ]
Information 08/03/2004 09:01:23 AM [JOBQUEUE]: Status changed from Active to Done. [Job No: 3] [Description: ]
Information 08/03/2004 09:01:03 AM 101 Restore Operation Failed.
Information 08/03/2004 09:01:03 AM 101 Number of Error(s)/Warning(s): 1/0
Information 08/03/2004 09:01:03 AM 101 Average Throughput: 0 KB/min
Information 08/03/2004 09:01:03 AM 101 Elapsed Time: 0s
Information 08/03/2004 09:01:03 AM 101 0 Database(s)/Transaction Log(s) (0 KB) Restored to Disk.
Information 08/03/2004 09:01:03 AM 101 0 Session(s) Found on Media.
-------------------------------------------------------------
[From Job Detail]
Job Summary

Restore from Media

Host Machine : SERVERNAME
Job Owner : caroot
Owner Password : ***************
Server Name : SERVERNAME


Source Targets
---------------

Media Required
---------------
Media Name Sequence Number Media ID
----------------------------------------------------------
6/08/04 4:00 PM 1 2b26


Destination Target
-------------------
\\DESTINATIONSERVERNAME <Windows NT/2000/XP/2003 Machine>




Schedule
---------
Run Now
Job Submitted : 8/03/04 9:28 AM



----------------------------------------------------------------------------
Source Targets

Device Group : NONE
Media Name : 6/08/04 4:00 PM

Media Statistics
-----------------
Media ID : 2b26
Sequence Number : 1
Session Number : 1
First Media Timeout : 5
Additional Media Timeout : 60
Location : NONE
Session Password : ***************

Backup Agent Restore Options
-----------------------------
Erase all data before restoring


Node Name
---------
NONE

Media Item : \\SOURCESERVERNAME\dbasql@MSSQLSERVER


Destination Target

Node Name
----------
\\DESTINATIONSERVERNAME <Windows NT/2000/XP/2003 Machine, Using Client Agent: @10.10.12.197>


User Name : sa
User Password : ***************

DISK # 1
---------


dbasql@MSSQLSERVER

Encryption Key : ***************

Disk Access : Regular File System Backup


----------------------------------------------------------------------------
Global Options
Operation Options
------------------
Create Whole Path for Destination

File Conflict Resolution
-------------------------
On Conflict Method, REPLACE (OVERWRITE)

Database Operation Option
--------------------------
Record Job Information Only

Log Option
-----------
Log All Activity

Pre/Post Job Execution
-----------------------
BEFORE Job Execution : NONE
Wait time (min) : 0
AFTER Job Execution : NONE

----------------------------------------------------------------------------
Run Options

Job Description : NONE

Schedule
---------
Run Now
Job Submitted : 8/03/04 9:28 AM

-----------------------------------------------------------------------------

CAN ANYONE HELP??

 

[Dito74]

I forgot the follwing info:
WINDOWS 2000 Server (Backup Server, Destination Server and Source Server)
BAB v11 is the software I'm using, also when I go to create the restore job, in the SOURCE tab, I right click on any session for "Agetn Option" selection and a window come up:

Backup Agent Restore Options

Is the voice "Log Point in Time Restore" supposed to be greyed out??

 

[juanic6]

I have the same problem !!! please help !!!!

 

[davidmichel]

Perhaps this will help
How can you restore a SQL database to a different location or database faq478-4748