easy, set your sql server to use windows authentication (not mixed mode) and users will only be able to access it if they have valid windows logon credentials.
you can also do some stuff in active directory server to restrict access by groups, roles, etc.
no subject
you can also do some stuff in active directory server to restrict access by groups, roles, etc.