SQL server: Can NT accounts be mapped to SQL server accounts

In our database we have an SQL server account that has the correct roles to access some of the databases. We are now switching to windows authentication and I was wondering if we can create a NT user group and map the privileges of the SQL server account to the NT user group? So if anyone in the NT user group is authenticated they will have the same privileges as the existing SQL server account.

Or would it be bet开发者_C百科ter to just delete the SQL server account and just assign roles to the NT group in SQL server?

JD.

As you originally had the correct roles associated with those SQL server account, I would use the roles to map with the NT User Groups.

When you add those NT Users into SQL Server, you should be able to assign those roles to those accounts.