Using NT Authentication with domain computer groups

With this method, each server is added to a specified domain computer group and each server accepts logins from members of that domain group. To authenticate your servers using domain computer groups, follow these steps:

  1. Create a Global Security Group in your domain containing your chosen servers. You might need to have domain administration privileges to do this.
  2. After creating the group, each server must be rebooted to update its domain credentials.
  3. On the Master Server, use SQL Server Management Studio to create a login for the domain group, with a default database of BFEnterprise, and give this login System Admin (sa) authority or the DBO (DataBase Owner) role on the BFEnterprise and master databases.