Backups fail if Builtin\Administrators group is removed

• 
  Change the service startup account for the SQL Backup Agent service. By default, it uses the LocalSystem account.
  
  The SQL Backup Agent service will log on to SQL Server using the credentials of the specified service startup user (Windows authentication). If you need the Agent to log on using SQL Authentication, do the following:
  
  - register the sqbsetlogin extended stored procedure

  sp_addextendedproc sqbsetlogin, 'xp_sqlbackup.dll'
  

  - call sqbsetlogin, passing in a user name and password
  sqbsetlogin 'sa', '<password>'
  
  - remove sqbsetlogin

  sp_dropextendedproc sqbsetlogin
  

  
  If you want to revert to Windows authentication, call sqbsetlogin with blank values i.e.

  sqbsetlogin '', ''
  

  petey January 18, 2006 18:48

  - 0 +
• 
  Msg 0, Level 11, State 0, Line 0
  A severe error occurred on the current command. The results, if any, should be discarded.
  
  I tried
  
  EXEC sqbsetlogin '',''
  
  and
  
  sqbsetlogin '',''
  
  I got the error both times. Any ideas?

  Wyatt70 January 23, 2006 13:26

  - 0 +
• 
  I think there was a bug where the status was reported wrongly (failure), but the change in settings were actually made. You can try running a small backup and trace via Profiler, to see the login used by SQL Backup.

  petey January 23, 2006 18:54

  - 0 +

Add comment

Please sign in to leave a comment.