Also... let me know if this is possible... We use terminal server instead of deploying our apps to individual computers. This way the front end and the database are on separate computers in the same location so we dont worry about performance over the WAN.
If we were to use Role-Based Security is there a way that we could log the user in automatically based on the user name they used to log into terminal server? This isnt a big deal but this would require that the user log in three times to get to the app, once on their computer, once to the terminal server, and again at the app. I realize that because of the way we're structured this isnt your fault i was just wondering if its possible.