Install Security

Reguarding best practices: when I am installing s SQL
Server Database, best practice would say that I do not use
the Domain Admin or the BUILTIN Admin account to run the
database under. If I cannot use these accounts, what do I
use? My network has Active Directory installed and we are
running on Win2000 servers."Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:8b5201c3e9a2$dbf005a0$a401280a@.phx.gbl...

quote:

---

> Reguarding best practices: when I am installing s SQL
> Server Database, best practice would say that I do not use
> the Domain Admin or the BUILTIN Admin account to run the
> database under. If I cannot use these accounts, what do I
> use? My network has Active Directory installed and we are
> running on Win2000 servers.

---

For fairly high level of security you can use a domain account with user
level domain permissions, on the server grant the permissions (user rights,
registry & NTFS permissions) found in this document:
http://support.microsoft.com/defaul...1&Product=sql2k
Stevesql

Install additional instance in a cluster

I am looking for a best practice or any suugestion on the best way to install an additional Sql 2005 instance in a cluster environment. We have a production environment that is active/active/passive and need to install an additional instance with a little impact to the current production instances as possible. Ant suggestions or articles I can review?

Hi...see the whitepaper at the following address:

http://www.microsoft.com/downloads/details.aspx?FamilyID=818234DC-A17B-4F09-B282-C6830FEAD499&displaylang=en

It contains multiple sections and information on installing Sql2k5 in a clustered environment...

HTH