SQLServer can't backup remotely (on Workgroups) unless Administrator?

From: Robert Steadman (robert.steadmanNO@SPAMvebra.com)
Date: 06/28/02 

From: "Robert Steadman" <robert.steadmanNO@SPAMvebra.com>
Date: Fri, 28 Jun 2002 09:56:59 +0100

I've had a problem a couple of times when, after installing SQL7 (sp4)
Desktop edition for clients (running Windows XP Pro) when attempting to use
SQL backup across the network to an NT Server. The error message is 'backup
device error or device offline'. It is caused (it seems) by the MSSQL
service user account not appearing to have sufficient access rights, but it
seems to ask for more than it needs - for example, when the account for the
SQL service has full access to the backup folder (and local administrative
priviliges) it still fails.

Books online says:
"Using a local account restricts SQL Server from interacting with other
servers. Some server-to-server activities can be performed only with a
domain user account. For example:
Remote procedure calls (RPCs)
Replication
Backing up to network drives ".
I am wondering if this problem is caused by the fact that they log into a
workgroup and not a domain - however it seems odd given that they appear (to
me) to have all the necessary rights.

On both occasions when the problem has appeared I have resorted to setting
the local SQL Server service to log on as the network administrator - which
seems to be a little extreme! Can anyone shed some light on this for me?

Thanks for any help.
Regards,

Robert Steadman
Craft Computers Ltd.

Relevant Pages

  • Re: SBS2003, NTBackup-Fehler
    ... Windows Server 2003 to resolve some VSS snapshot issues ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Scheduled Backup for SQL Database
    ... Look in the SQL Server log too, ... Need smaller SQL2K backup files? ... >>Need smaller SQL2K backup files? ...
    (microsoft.public.sqlserver.server)
  • SQL/ MS 2003 server backups/restores
    ... I'm a bit confused on the backup necessary for my SQL server running on MS ... system state, OS etc, and another for my SQL databases. ...
    (microsoft.public.sqlserver.server)
  • Re: VSS event 6013
    ... I am experiencing a similar issue where VSS tries to access my SQL ... Server every time I perform a system state backup. ...
    (microsoft.public.windows.server.sbs)