Thanks everyone. I set up a security group in AD and added it in SQL as a datareader. It seems to be working.

After more testing, I'll let you...