SS05 : use local user account for services account ?

Why not?

It depends on your aim. Is this SQL Server 2005 instance will be a test
instance? As you'll be installing it on a laptop obviously it's not going to
be used as a server for others. So of course you can use a local user
account as your SQL Server service account.

However, you'll need to change your SQL Server instance' s service accout
using SQL Server Configuration Manager. Because some local Windows Groups
are built by SQL Server Setup and appropriate rights are given to these
groups to run SQL Server services and if you modify your SQL Server' s
service account using SSCM then that user account will be added to these
built-in groups so it'll have enough rights to make your SQL Server instance
run.

Or you can use Local Service account and other system accounts but I want
you to be aware of the powers of Local System account which has
administrative rights on your system. And another system account Network
Service account has network permissions as its name refers.

--
Ekrem Önsoy



"John A Grandy" wrote in message

> Apparently it's not possible to use a local user account as the service
> account for the SQL Server 2005 ?
>
> I'm installing on a standalone laptop that's not a member of any domain.
>
> What's the best strategy here ?