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

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 07/03/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Wed, 03 Jul 2002 09:22:44 -0600

It's likely related to what you are using for your service
accounts. If you need to access network resources, you need
to run the accounts under domain accounts with appropriate
access to the other network resources.

-Sue

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

>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: Restoring a SSP 3.0
    ... First of all you need to make sure that all accounts are correctly configured and with the right permissions to SQL Server. ... Backup ContentDB in SQL Server using SQL Managagement Studio ... Create a new SearchDB or restore the old one and attach it to new SharePoint. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: XP Clients falling off network
    ... > your predecessor knew this practice was normal and set the accounts to ... At Server Management goto Users open an account, ... >>I just inherited an SBS domain with several W2K Pro clients and two XP ... >> appears when trying to access network resources that says ...
    (microsoft.public.windows.server.sbs)
  • Re: Task Scheduler Problems Server 2003 Enterprise
    ... network resources, make sure the user account has permissions to the ... | No matter what permissions I give the task scheduler ... | domain or local accounts,) my tasks won't run when I'm ...
    (microsoft.public.windows.server.general)
  • Re: Services Account
    ... differences is that local system accounts can't access ... network resources and Domain accounts can be allowed access ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie question on SQL connection
    ... > Let me educate you about SQL Server security. ... granting permissions to these accounts in SQL ... > maintain its own user accounts, which are separate from domain user ...
    (microsoft.public.dotnet.framework.aspnet)
Quantcast