As far as I'm aware, no version of SQL server actually requires Active Directory at all in order to function--you can install them on a standalone server if you wish. Obviously that presents some potential management issues with permissions and the like, but it's doable.