• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1212
  • Last Modified:

Unable to backup SQL server using BE 12

When I attempt to backup our SQL server it fails, Backup Exec cites a problem connecting to the remote agent (connection to the server failed)

When I remote on to SQL there is the following error in the system log:

Event Type:      Error
Event Source:      VsJITDebugger
Event Category:      None
Event ID:      4096
Date:            23/04/2009
Time:            11:56:05
User:            NT AUTHORITY\SYSTEM
Computer:      WPHSQL
Description:
An unhandled win32 exception occurred in beremote.exe [2860]. Just-In-Time debugging this exception failed with the following error: Debugger could not be started because no user is logged on.

Check the documentation index for 'Just-in-time debugging, errors' for more information.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 02 00 5c 80               ..\€    

I have tried re-installing the agent and rebooting both the BE server and SQL.

I have tried to turn off Visual Studio 2005 just in time debugging but error still appears.

Any ideas?
0
WPHIT
Asked:
WPHIT
  • 5
  • 3
  • 2
  • +1
1 Solution
 
nalanbarCommented:
Does the remote server have a valid user account for the BUE process?
0
 
WPHITAuthor Commented:
Forgive me is the BUE process the Backup Exec account?

At the moment the agent service is running using "Local System" I can change it to run using our backup account which is a domain admin?

Thanks,

WPH
0
 
RiteshShahCommented:
I am sure this is rights issue, you can use powerful user of domain for this process.
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
nalanbarCommented:
Yes. BUE=BackUp Exec. :)
Does it run as local system by default? I seem to remember that the agent had to run as a user account, and the server has to connect with those credentials.
YMMV
0
 
WPHITAuthor Commented:
All my other agents run as local system, I have changed the BE service on SQL now to use a domain admin account (the BUE account). I am running a job and will update you.
0
 
RiteshShahCommented:
it should run for sure this time, if there is a permission issue.
0
 
WPHITAuthor Commented:
I changed the BE Remote Agent service on SQL to run as a domain admin account, as oppose to local system account.

I started the same backup job off again and it failed, citing the same error above, something about debugging beremote.exe.

I then ran the Resource Credentials test (within the job) and all credentials passed for the SQL server & its databases.

I've subsequently reverted back to running the agent as local system, as who the service logs on as does not seem to make any difference. BUE is connecting to the server as a domain admin to back it up anyway, so it was a long shot.

Sorry guys, any more ideas?

0
 
nalanbarCommented:
Remove Visual Studio. We might at least get some valid error logs then! :)
0
 
WPHITAuthor Commented:
I am removing Visual Studio and will re-try a backup and update you.
0
 
WPHITAuthor Commented:
I removed Visual Studio and did a reboot.

Now I tried another backup, we're getting the same error:

Symptoms are:

1) Backup fails citing connection lost to SQL
2) The remote agent on SQL enters the stopped state
3) the following entry is posted into the system log:

Event Type:      Error
Event Source:      VsJITDebugger
Event Category:      None
Event ID:      4096
Date:            23/04/2009
Time:            13:13:53
User:            NT AUTHORITY\SYSTEM
Computer:      WPHSQL
Description:
An unhandled win32 exception occurred in beremote.exe [2176]. Just-In-Time debugging this exception failed with the following error: Debugger could not be started because no user is logged on.

Check the documentation index for 'Just-in-time debugging, errors' for more information.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 02 00 5c 80               ..\€    
0
 
DKHeneryCommented:
WPHIT I just started having this same issue. I found that if I do not use AOFO the backup runs fine, However, I really want to back up this server up as part of a Multi server job and want to use AOFO across the board, aslo I have other SQL Servers of the same version that bacxkup fine so there has to be a fix of some kind.

If you do not need to use AOFO then just disable it and you backup will complete with Open File Acceptions

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 5
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now