Hello, it appears a Local User account is the most recommended for SQL
Server to run it's services under so then should this be setup in the
machine's right click My Computer -> Manage -> Local Users and Groups and
just create a new user named something like SQLServerServiceUser &
SQLAgentServiceUser in which these can be selected as when running the SQL
2005 setup disk?...or does this account need to be created afterwards and
assigned permissions? It's a bit confusing since I'm at the 'Service
Account' section in the 'Microsoft SQL Server 2005 Setup' wizard and it only
lists and allows 'Local system' and 'Network service' in the 'Use the
built-in System account' dropdown as to where it sounds like it's not good
practice to use the 'Use a domain user_account' option instead?

Nevermind this question as I ended up stepping through it and appears it's
setup running as the local user account that I'd created.

But a little confused in when opening up Management Studio now after the
install the logon popup box is listing 'Windows Authentication' and the
'User name' field disabled listing the domain\administrator account in that
is this correct to logon as the domain\administrator instead of the local
user account that it's running as? Thanks in advance.




"7777" <NoSpam (AT) NoSpam (DOT) com> wrote

Hello

For installation, you want to set up SQL Server using a login that has
administrator previledge on the system. As for the SQL Server Service
account, that depends, you can use the local account or domain account. In
some, local account is enough whereas in others use domain account to access
resource in the domain. I guess the rule of thumb is to set it up with the
account with the least permission necessary to do the job.

When you are opening the Management Studio, and select the Windows
Authentication ... yup that user name will be disabled. It is showing
'domain\Administrator', because I am assuming that at that moment you are
login into the system as 'domain\Administrator'. It is not actually the
account that is being use to run SQL Server Service.

If you want to look on what account is being use to run the SQL Service, you
can go to 'SQL Server Configuration Manager' (under Start > Programs >
Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration
Manager). Or you can go to control panel and then services, and search for
SQL Server services.

Hopefully that answer your questions.

Thank you
Lucas

"7777" wrote:

Yes, you are correct and think I see the differences. Thanks for your
helpful speedy reply Lucas, much appreciated. Cheers :-)


"Lucas Kartawidjaja" <LucasKartawidjaja (AT) discussions (DOT) microsoft.com> wrote in
message news:AAD8CEDC-C0A9-480A-921C-45B834003EC6 (AT) microsoft (DOT) com...