SQL Server Service Permissions

[ktai]

I am setting up SQL server to automatically backup to a network share. Right now I am getting 'access denied' errors because the SQL services are still set to use the local system account. If I change the SQL Server Service to use a domain account, what priviliges does that account need? I know the account would need full permissions on the network share, but what about on the computer running SQL server?

Thanks!
Kris

 

[mrdenny]

It needs to have the log on as a batch job and log on as a service.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com