Link to home
Start Free TrialLog in
Avatar of WPHIT
WPHITFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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?
Avatar of nalanbar
nalanbar
Flag of United States of America image

Does the remote server have a valid user account for the BUE process?
Avatar of WPHIT

ASKER

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
I am sure this is rights issue, you can use powerful user of domain for this process.
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
Avatar of WPHIT

ASKER

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.
it should run for sure this time, if there is a permission issue.
Avatar of WPHIT

ASKER

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?

Remove Visual Studio. We might at least get some valid error logs then! :)
Avatar of WPHIT

ASKER

I am removing Visual Studio and will re-try a backup and update you.
Avatar of WPHIT

ASKER

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               ..\€    
ASKER CERTIFIED SOLUTION
Avatar of Dan Henery
Dan Henery
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial