Thank you for the reply. I had thought about using the application role like you suggested and will probably go that route. I will also consider adding a data tier.

John