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:
- Create a Global Security Group in your domain containing your chosen servers. You might need to have domain administration privileges to do this.
- After creating the group, each server must be rebooted to update its domain credentials.
- 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.