|
Home > Archive > MS SQL Server > April 2006 > Install SQL 2000 Enterprise on a member server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Install SQL 2000 Enterprise on a member server
|
|
| tractng@gmail.com 2006-04-03, 3:23 am |
| Guys,
I want to install sql server which would allow all Enterprise Admin to
log onto the server without distrupting services. So do I choose the
option run as local (local system account) service like any other type
of software that you normally would install? Thanks in advance.
Thanks,
Tony
| |
| Dan Guzman 2006-04-03, 7:24 am |
| The SQL Server service account does not affect which accounts can log in.
The service account specifies the security context used by SQL Server when
accessing external resources like files and shares. As long as you don't
need to access file shares from the SQL Server service (e.g. backup/restore
from network UNC), the local system account may work fine. However, the
Best Practice is to use a minimally privileged account. Personally, I
always use a domain account.
See the Books Online for more information.
--
Hope this helps.
Dan Guzman
SQL Server MVP
<tractng@gmail.com> wrote in message
news:1144039530.633303.218110@e56g2000cwe.googlegroups.com...
> Guys,
>
> I want to install sql server which would allow all Enterprise Admin to
> log onto the server without distrupting services. So do I choose the
> option run as local (local system account) service like any other type
> of software that you normally would install? Thanks in advance.
>
> Thanks,
> Tony
>
|
|
|
|
|