Kevaburg, you were correct in saying it wouldn't work. I was trying to explain the situation to the other 2 posters why I didn't have the luxury of using other methods to accomplish this. I am bound by Tableau Server.
I am putting in a request to add another authentication method where it will pass the AD credentials through from the Tableau Server login to the backend DB. I am not a coder but it doesn't seem to be that difficult of a request. It seems pretty standard these days. Talking with one of their engineers, they did mention that having the each AD login defined in SQL instead of using groups allows for row level security at the user level which Tableau will respect. It just seems strange that they would force you through this model when you aren't using row level security...so we will see where the tool goes.
Thanks for the input everyone. I just wanted to make sure I wasn't missing any other options here.