• Sounds like you need to create the user based on the login then assign the nessesary roles to the user

    Add something like the below to your script

    CREATE USER [Domain\GroupName] FOR LOGIN [Domain\GroupName]

    GO

    EXEC sp_addrolemember N'db_owner', N'Domain\GroupName'

    GO

    Repeat the addrolemember for the different roles you want to grant the login