SQL user

[Thomas B]

I perform full backup on MSSQL2000
However, the directory of backup files is only writable by Administrator

But I find that I can't backup (I think it is due to permission)
In which role MSSQL2000 is running?

In Service->MSSQLSERVER
It is set to Local System Account,
Can I just change to Administrator? Is there any side effect?

[Allan Mitchell]

Re: SQL user

The local System account is a "can do anything locally" account. It cannot
however see past its own disk drives.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Thomas B" <bolero92@yahoo .com> wrote in message
news:6592092f.0 404292109.1d873 8a4@posting.goo gle.com...[color=blue]
> I perform full backup on MSSQL2000
> However, the directory of backup files is only writable by Administrator
>
> But I find that I can't backup (I think it is due to permission)
> In which role MSSQL2000 is running?
>
> In Service->MSSQLSERVER
> It is set to Local System Account,
> Can I just change to Administrator? Is there any side effect?[/color]