What permissions are required for the SQL safe Backup Service logon account?
The logon account for the SQL safe Backup Service requires the following permissions: The service account must be a member of the “system administrators” role on the SQL Server you intend to backup or restore. The service account must have the following local rights: • “log on as a service” • “impersonate a client after authentication” if running on Windows 2000 SP4 or later, or • “act as part of the operating system” if running on Windows 2000 SP3 or earlier. The service account will need permission to read and write registry values in “HKEY_LOCAL_MACHINE\Software”. When debug logging is enabled for the SQL safe Backup Service, it attempts to create log files in the root SQL safe directory (by default this is “C:\Program Files\Idera\SQL safe”), so the account will need permission to write to this location as well. As one final note, you may want to give the Backup Service account certain filesystem permissions when performing SQL safe restore operations using the “withmove” option. Be
