Hi,

I am fairly new to sql2005 and have sql2005 Developer edition. I am loading
it on one-desktop (xp pro SP2) to learn how to upsize our Access dbs.

Can any one recommend the best Service Account setup.

1) Customize for each service account

2) Use a built-in sys account

3) use a domain user account

Does the domain user account mean the same thing as the domain user account
I use to login to my machine?

'Best' is always up to interpretation and need. However, these articles will
arm you with enough information that you can make the best choice for your
situation.

Configuration -Service Accounts, SQL Server 2005 - Setting Up Windows
Service Accounts
http://msdn2.microsoft.com/en-us/library/ms143691.aspx
http://msdn2.microsoft.com/en-us/library/ms143504.aspx

Configuration -Service Accounts, SQL Server or SQL Server Agent service
account
http://support.microsoft.com/kb/283811/en-us
http://msdn2.microsoft.com/en-us/library/ms143691.aspx

Configuration -Service Accounts,Selecting an Account for the SQL Server
Agent Service
http://msdn2.microsoft.com/en-us/library/ms191543.aspx
http://support.microsoft.com/kb/907557


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"thersitz" <thersitz@gmail.com> wrote in message
news:%23a4AL44$GHA.4212@TK2MSFTNGP02.phx.gbl...
> Hi,
>
> I am fairly new to sql2005 and have sql2005 Developer edition. I am
> loading it on one-desktop (xp pro SP2) to learn how to upsize our Access
> dbs.
>
> Can any one recommend the best Service Account setup.
>
> 1) Customize for each service account
>
> 2) Use a built-in sys account
>
> 3) use a domain user account
>
> Does the domain user account mean the same thing as the domain user
> account I use to login to my machine?
>