I am surprised the Security Administrator Role is not working. You are granting the appropriate database access as well? They need to be granted access to the default database for the login, if not, they will not be able to add it.
You could also set up Windows Groups as a System Administrator and as long as they have permission to add a Windows login to the appropraite group, the permissions travel to the database as well.
Kevin
Discuss This Question: