I'm rebuilding our SQL 2000 box and trying to figure out the best way to configure the permissions settings. The first question is whether to use a local or domain account for the SQL service account.

What have other people setup for permissions on servers for Database Administrators? Do you just give them full administrator access to the entire server? I was ...