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

From: Robert Steadman (robert.steadmanNO@SPAMvebra.com)
Date: 07/01/02 

From: "Robert Steadman" <robert.steadmanNO@SPAMvebra.com>
Date: Mon, 1 Jul 2002 16:12:44 +0100

Hi Michal,

Thanks for the reply.
I removed SQLAgent from the equation by backing up directly from Query
Analyzer - same problem appears. It could well be some restriction in the
desktop version (undocumented of course!!) I find it all a bit
baffling........

Regards,

Robert Steadman
Craft Computers Ltd.

"Michal Mikulik" <michal.mikulik@deltax.cz> wrote in message
news:1436901c220f8$89085c80$3bef2ecf@TKMSFTNGXA10...
> Hi Robert,
>
> check two things:
> 1/if backups are scheduled through Maintenance Plans, then
> SQL Server Agent must be started under stronger account,
> not SQL Server itself.
> 2/I'am not sure about NT authent possibilities in Desktop
> Editions. I'd guess it is restricted in this edition.
>
> Hi
> Michal
>
> >-----Original Message-----
> >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: Unable to Backup on Network
    ... service accoutn from the 'Local System' account to a specific account. ... I like to log in to the SQL server console as the service account to test ... > The operating system on which my SQL Server 2000 is there is Windows 2000> Server while i want to take the backup on another computer on network which> also has same operating system. ...
    (microsoft.public.sqlserver.security)
  • Re: backing up to network share issue.
    ... I guess I was confused by your later text where I read it as if you stated that it would be the Agent account ... Tibor Karaszi, SQL Server MVP ... >> impersonation when it accesses the backup file on behalf of the SQL Server ... >>> As Tibor stated, this is not an SQL Server issue, it is a network ...
    (microsoft.public.sqlserver.msde)
  • Re: User authentication
    ... There are 2 SQL Server 2005 ... 1 SQL Server 2000 installed on another server ... Windows account instead to run backup jobs. ...
    (microsoft.public.sqlserver.clients)
  • Re: Transaction log backup
    ... Main plan is totally reworked in SQL Server 2005. ... > to issue a BACKUP log to a db in SIMPLE recovery makes zero sense. ... >> account is the security context for jobs, ...
    (microsoft.public.sqlserver.server)
  • Re: backing up to network share issue.
    ... impersonation when it accesses the backup file on behalf of the SQL Server uses that executed the backup ... SQL Server just uses the SQL Server service account when accessing the backup share. ... > As Tibor stated, this is not an SQL Server issue, it is a network ...
    (microsoft.public.sqlserver.msde)