"TJ" <T*@discussions.microsoft.com> wrote in message
news:710B7F2F-F989-4DD3-B5EA-30A4C2F60425@microsoft.com...
> Hi,
>
> Environment : Win Svr 2003/SQL Svr 2000
>
> As far as I know, to specify a UNC path for backup location, MSSQLServer
> service should be running with an account that can access network
> resources...
> As you know, by default, SQL Svr 2000 is installed with LocalSystem
> account.
> Prior to the release of the Win200 OS, LocalSystem account can't access
> network resources, but with the release of Win2000, the account has been
> changed to allow authentication to network resources...
>
> However, according to my testing, when I run the MSSQLServer service with
> LocalSystem account, a UNC path couldn't be used for the backup location,
> however, the service running with an account such as an administrator that
> has network access rights, a UNC path could be
> used for it.
>
> Is my understanding something wrong?
> Since the LocalSystem account was modified to allow authentication to
> network resources, should it work a UNC path for backup location when the
> SQL
> service is running with LocalSystem account?
>
>
> Thank you in advance.
>
> ........................................................................TJ
>
>