Beginner - SQL Server 2008 Express Installation

i want install sql server 2008 express advanced services on clean (just reinstalled windows) xp pro system. have small home workgroup network. use dbms development/learning purposes. test access dbms pc on network. more interested in being easy use tight security, nothing of value ever in db, , person uses dbms. develop with visual studio 2008 (c# , asp.net), visual basic 6, , asp, , in cases want able access sql server db's i  create. don't need more used access.

 

in past have installed 2005 express version, , management studio, , in general accepted defaults - choice ever had make windows authentication vs mixed mode comfortable about. able needed.

 

this installer wants me choose couple of things don't understand:

1. default instance vs named instance?

i want one ordinary sqlexpress, got default 2005 express. make difference whether choose 'named instance' name of sqlexpress, or 'default instance', the sqlexpress name seems assigned automatically?

 

2. service accounts

i never needed with service accounts 2005 express. perhaps the installer assigned defaults me, don't know were. want minimum hassle, lowest security, least-likely-to-make-programming-hard answer. 

do have go , create new user in computer management - local users , groups?

does matter call it, or password give i.e. of programs, connection strings etc. ever need reflect choose?

do have assign privileges etc, , if how?

what equivalent used 2005 express, without having anything?

2 - correct, windows maintains passwords system accounts - don't ever know or see them.

3 - yes - sql server provisions whichever account(s) select during setup permissions required run sql server service.  in production environment, dedicated domain account set each service, in order allow account access network resources it's applications may require.

4 - sure.  may not use full-text search, depending upon requirements.

 

hope helps!

 

SQL Server  >  SQL Server Express