CREATE LOGIN [YourID\Danny] FROM WINDOWS WITH DEFAULT_DATABASE = YourDatabaseName, DEFAULT_LANGUAGE = English GO CREATE LOGIN [YourID\DBAs] FROM WINDOWS WITH DEFAULT_DATABASE= YourDatabaseName GO