WPHIT
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?
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?
Does the remote server have a valid user account for the BUE process?
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
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
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
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.
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?
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! :)
ASKER
I am removing Visual Studio and will re-try a backup and update you.
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 ..\€
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.