I've recently been handed the DBA role for the company and I'm currently studying for the 70-432, then 70-433. I'm extremely new to the Database world and SQL in particular, but have used Access for different classes in college.
I'm in the process of building two brand new servers from the ground up and need to know "real world" or "Microsoft Best Practices" for setting up service accounts. My platform is Server 2008 R2 Standard 64-bit and I'm installing SQL
2008 R2 Enterprise 64-bit. We're also on vituralized enviroment using EqualLogic and VMWare.
We have one service account currently that is part of "Domain Admins" and "Domain Users" and I know this is too much.
I want to know how many service accounts I need to create before installation and the permissions for each.
There is always a way...
View Complete Post