Abu Dina (11/20/2012)
Thanks Tony.I have more questions sorry! if anyone can point me in the right direction I'd be eternally grateful!
1) The new box will not have any locally installed application that access the database. I'm also not using Full-text service so can I just remove the NT AUTHORITY\SYSTEM login?
2) I want to set up the server so it will have 5 Developers and 2 DBAs. What's the best way to set this up?
1 - No leave that login where it is, if SQL has created it, it has created it for a reason.
2 - I take it as this is in the DMZ that it is not part of the domain? If so create the logins as local logins, then create 2 local groups, assign the logins to the groups, assign the groups the permissions they need in SQL.
Also can you explain your reasonings behind putting a SQL server in the DMZ? Typically you would want your databases to be on the secure LAN protected by firewalls etc.