I don't have time to hunt the reference down right now, but SQL isn't supported on a server in application mode.
I agree with you even if that weren't the case. Regards, Michael B. Smith MCSE/Exchange MVP http://TheEssentialExchange.com From: Phil Guevara [mailto:[EMAIL PROTECTED] Sent: Thursday, February 07, 2008 3:32 PM To: NT System Admin Issues Subject: Question about Terminal Server - Security and Performance I was hoping to get some opinions on this from both views. Let's say we have a software program similiar to a Helpdesk program, except that many other departments can use it for their purpose. This software has 3 parts, the SQL backend, the server front end, and the client software. Well my colleague has suggested placing the SQL backend, the server front end and the client on the same beefy server and allow users to RDP into that box to access the client. I have opposed this idea and stated we should have the SQL Backend and the server front end on that beefy box and then the client should be on a seperate terminal server box that the users can connect to. My argument was that there is a security issue with allowing users to RDP into the same box as the server front end and SQL back end. His argument is that performance will be better. Can anyone validate or strengthen my claim or his claim? We are going to have a debate about this. Best Regards, Phil ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
