Re: Granting computer account access to file shares




"Bill Bradley" <BillBradley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:116B274E-1304-443F-94B8-E03EE56558E8@xxxxxxxxxxxxxxxx
I was under the impression that you could grant a computer access to a file
share folder, and, that that would allow the computers System account to
access the folder?

I am trying to setup a SQL 2005 database to backup to a file share folder
via a UNC path. I've added in the computer the database resides on to the
share and the folder's NTFS rights will Full (tried Modify, first) Rights,
but, the backup still fails.

I cannot change the SQL database from using System, so, cannot setup a
Domain User and give that user rights, so, was trying it this way.

Thanks.

The System account does not have any access to any networked
resources. You need to use the Task Scheduler to back up your
database and run the task under a domain account with appropriate
privileges.


.



Relevant Pages

  • RE: Sharepoint Backup & Restore
    ... even you have moved the Sharepoint database to another location. ... You can delete the $NtUninstallxxxxxx$ folder to free up space. ... Perform an online backup of the Exchange 2003 Information Store to purge ...
    (microsoft.public.windows.server.sbs)
  • Re: Need help finding a 3rd party database rebuild tool
    ... It's advised by the developers not to let Time Machine backup your Entourage ... If the database is copied while being used, ... folder and create an iCal event to copy it over at night while not in use so ...
    (microsoft.public.mac.office.entourage)
  • Could not open that feature. Mail error.
    ... Because of an apparent error in the code for this discussion board, ... I can't try and drag the folder out to the ... One further comment - I DO backup my mail database every now and then, ...
    (microsoft.public.mac.office.entourage)
  • Re: Problems installing to a new PC
    ... copied "Windows\Embedded\Data" folder to a second drive that I used for my database backup before I uninstalled the Component database manager so I can restore it after I install the upgrade. ... it was giving me an error on the database file on the second drive that has the backup files so I renamed the backup folder and I got thru the installation fine. ... Did you install VS 2005 with SQL Express before installing XPe? ...
    (microsoft.public.windowsxp.embedded)
  • Re: sql server 7.0 backup script.
    ... COmpile the below stored procedure in Master database and define the folder ... in which backup needs to be taken. ... SQL Server MVP ...
    (microsoft.public.sqlserver.clients)

Loading