Sqlism (8/7/2012)
Question 1) these accounts shoulb be AD accounts,am i right?
Question 2) Creating Service accounts is job of DBA? I think it should be done by systems/network team(plz clarify)
Question 3) These same 5 accounts will be used in dev and future prod box, condition is that service accounts password should be different in DEV and QA, how can i fulfill this?
#1 - It depends on how things are set up at your company, but I would recommend AD accounts, configured as ones that cannot be locked out. Another note, these accounts should not be granted logon to the server/workstation.
#2 - The DBA/team can request the creation of AD accounts, but in my experience it's the System/Network team. However if the system/network team is going to allow you to do it and grant you access to do so, I'd be tickled...
#3 - ??? How can you fulfill it? Can't you just ask them to make the account passwords different ???
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience