Hello SQL DBAs
I'm new to SQL Server and I want to learn how to do things the right way. I'm getting ready to install SQL Server 2008 R2 into my test domain. I have created two AD accounts: sql_sqlserver (for the SQL Server service) and sql_agent (for the SQL Server Agent service). I have added both sql_sqlserver and sql_agent to the local admin group on my test SQL server. I have also added sql_agent to the "Pre-Windows 2000 Compatible" group. My question is this:
When I do the actual installation of SQL Server 2008 R2, should I be logged on as myself (a member of the domain admin group) or should I be logged on as sql_sqlserver (a member of the local admin group). I'm thinking I should be logged on as sql_sqlserver, but I want to be sure this is the best practice.