When performing a restore of Microsoft SQL Databases, the error "Authentication failed on connection to the server" occurs.
Exact Error Message
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
Details:
When attempting to perform a restore of Microsoft SQL
Databases, the first two characters of the server name may be truncated in the
restore destination. The error "0xe000fe29 - Authentication failed on connection
to server. Make sure that the user account has the appropriate permissions and
that the password was typed correctly" is returned in the job log.
The
errors in the job log body are as follows:
Restore -
RVER
The Media
Server was unable to connect to the remote machine RVER. The machine could not
be found on the network.
The Media
Server will fall back on the on the local agent and try to complete the
operation.
Access is
denied to Remote Agent.
Note: The Server name SERVER has the first two
characters truncated in the above
message.
Workaround:
1. Open
the %windir%\system32\drivers\etc\hosts file with Notepad or some
other text file editor
2. Add an entry or modify an
existing entry for the restore target server that includes the IP address and
the server name minus the first 2 characters. For example:
192.168.1.1 RVER
3. Save the file with the
changes.
Note: Be sure to remove this entry after the
restore completes to prevent issues with backup or other application
connectivity to the server.
A hotfix is now
available for this issue in the current version(s) of the product(s) mentioned
at the end of this article. Refer to the Hotfix link under Related Documents at
the end of this article to obtain the hotfix needed to resolve the
issue.
Related Documents:281295: be5629RHF10_281295.exe BEWS 10.1.5629R Hotfix 10 - Unable to select Lotus Domino databases, Microsoft SQL database restore truncates first two characters of server name, Policy based backups\export jobs are not sending job log with notification, Remote Agent for Windows Servers causes access violations during restore http://support.veritas.com/docs/281295287295: be5629RSP3_287295.exe Symantec Backup Exec (tm) 10.1 (10d) for Windows Servers revision 5629 - Service Pack 3 - Includes Critical Security Updates http://support.veritas.com/docs/287295282818: be5629RSP1_282818.exe Symantec Backup Exec (tm) 10.1 (10d) for Windows Servers revision 5629 - Service Pack 1 - Includes Critical Security Updates http://support.veritas.com/docs/282818285482: be5629RSP2_285482.exe Symantec Backup Exec (tm) 10.1 (10d) for Windows Servers revision 5629 - Service Pack 2 - Includes Critical Security Updates http://support.veritas.com/docs/285482290905: BE5629RSP4_290905.exe Symantec Backup Exec (tm) 10.1 (10d) for Windows Servers revision 5629 - Service Pack 4 - Includes Critical Security Updates http://support.veritas.com/docs/290905304478: Error 0xe000fe29 - "authentication failed on connection server. make sure that user account has appropriate permissions and that password was typed correctly" occurs when attempting to backup NAS (Network Attached Storage) Machine http://support.veritas.com/docs/304478328478: How to troubleshoot "Access Denied to Remote Agent" and/or "Authentication failed on connection to the server" errors which occur when a backup or restore is attempted http://support.veritas.com/docs/328478
Supplemental Material:| System: Ref.# | Description |
| ETrack: 496065 | SQL restore truncates first two characters of the server name or IP |
| Error Code: 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. |
Products Applied:
Backup Exec for Windows Servers 10.0, 10.0 5484, 10.0 5484 SP1, 10.0 5484 SP2, 10.0 5520, 10d (10.1), 10d (10.1) 5629
Subjects:
Backup Exec for Windows Servers
Application: Restore, Sql Module
Languages:
Danish, Russian, English (US), French, German, Spanish, Italian, Japanese, Korean
Operating Systems:
Windows 2000Advanced Server, Advanced Server SP1, Advanced Server SP2, Advanced Server SP3, Advanced Server SP4, Advanced Server Windows Powered, Advanced Server Windows Powered SP1, Advanced Server Windows Powered SP2, Advanced Server Windows Powered SP3, Advanced Server Windows Powered SP4, Datacenter Server, Datacenter Server SP1, Datacenter Server SP2, Datacenter Server SP3, Datacenter Server SP4, Professional, Professional SP1, Professional SP2, Professional SP3, Professional SP4, SAK, Server, Server SP1, Server SP2, Server SP3, Server SP4, Server Windows Powered, Server Windows Powered SP1, Server Windows Powered SP2, Server Windows Powered SP3, Server Windows Powered SP4
Windows XP
Pro 5.1, Pro 5.1 SP1, Pro 5.1 SP2
Windows Server 2003
DataCenter, DataCenter (IA64), DataCenter (x64), DataCenter SP1, DataCenter SP1(IA64), Enterprise (IA64), Enterprise SP1(IA64), Enterprise Server, Enterprise ServerSP1, Standard Server, Standard Server SP1, Standard Server(x64), Storage Server, Storage Server SP1, Web Server, Web Server SP1
THE INFORMATION PROVIDED IN THE SYMANTEC SOFTWARE KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. SYMANTEC SOFTWARE DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL SYMANTEC SOFTWARE OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES,EVEN IF SYMANTEC SOFTWARE OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.
E-Mail this document to a colleague