SQL Restore - Redirection

[BRETT_LINDSEY_2]

SQL 2000
BEXEC 10 w/ SQL agents

Hi- I'm attempting to restore a few databases onto SQLSERVER2 from a backup tape that originally backed up SQLSERVER1. (same versions of Backup EXEC - V10)

**SQLSERVER1 has since been shutdown/rebuild as a new server.

When attempting to run a restore using the 'SQL Redirection' feature within BEXEC (ie: Restore the DBs to SQLSERVER2 as SQLSERVER doesn't exist anymore). I'm presented with the following error:
Final error: 0xe000fe29 - Authentication failed on connection to the server. Make sure that the user account has the appropriate permissions and that the password was typed correctly.

While setting up the restore job, I noticed within the 'Resource Credentials' option its attempting to connect to my old SQLSERVER1 to verify the credentials are tested successfully. .... as this server is offline, it fails.

Any ideas?

Thanks
Brett

[shweta_rege]

Hello,

- Kindly refer the following document:

When performing a restore of Microsoft SQL Databases, the error V-79-57344-65065 "Authentication failed on connection to the server" occurs.

http://support.veritas.com/docs/280754


******************************************************************
*****************************************************************

Note : If we do not receive your reply within two business days, this post would be marked �assumed answered� and would be moved to �answered questions� pool.


Thanks.

[BRETT_LINDSEY_2]

That is not the issue we're having; below is the error log.

Job Operation - Restore

Server - SQLSERVER2
Access is denied to Remote Agent

Job Completion Status
Job ended: Friday, February 10, 2006 at 12:33:37 PM
Completed status: Failed
Final error: 0xe000fe29 - Authentication failed on connection to the server. Make sure that the user account has the appropriate permissions and that the password was typed correctly.
Final error category: Security Errors

For additional information regarding this error refer to link V-79-57344-65065


Errors
Click an error below to locate it in the job log
Restore- SQLSERVER2 Access is denied to Remote AgentMessage was edited by:
BRETT LINDSEY

[Gauri_Ketkar]

Hi,

-create a new logon account with correct username and password from

network > logon account > new > restricted

-create a new job and select this new account "resource credentials"

-also can you select and start a backup of new SQL server with this account ?

additional info :

How to restore SQL 2000 databases using a database backup in Backup Exec 9.x
http://support.veritas.com/docs/262171

Update us on the same and revert for any further Query
Hope this will help you


Thank you
Gauri

Additional Information :
For information on the recent VERITAS Backup Exec security vulnerabilities, including links to the downloads for the necessary hotfixes, please refer to the following document:
Patch summary for Security Advisories VX05-001, VX05-002, VX05-003, VX05-005, VX05-006, VX05-007

http://seer.support.veritas.com/docs/277429.htm



NOTE : If we do not receive your reply within two business days, this post would be marked "assumed answered" and would be moved to "answered questions" pool.