Slow open file dialog in Excel on Terminal Services 2008

I think i've made progress! Microsoft recommended i add WINWORD.exe, EXCEL.exe and Outlook.exe to DEP (Data Execution Prevention). (Silly I know considering it's a microsoft product!)

So far so good - havnt had a crash for 6 hours considering we would have up to 12 crashes in 1 hour. I'll keep you posted.

If you wish to test for yourself follow the instructions below.

• Click Start, click Run, type sysdm.cpl, and then click OK.
• On the Advanced tab, under Performance, click Settings.
• On the Data Execution Prevention tab,
• Make sure The option "Turn on DEP for all programs and services except those I select" is selected
• Example: Add: c:\Program Files (x86)\Microsoft Office\Office12\excel.exe
• Add all exe files for Outlook, word and excel.

* UDPATE *

Just to let you all know im confirming the above solution has resolved our problems with Word/Excel etc freezing up.

•Terminal Services Web Access:

main benefit:

With TS Web Access, a user does not have to start the Remote Desktop Connection (RDC) client to start a RemoteApp program. Instead, they access the Web page, and then click a program icon. For details see Terminal Services Web Access (TS Web Access)

•Terminal Services Gateway

main benefit:

TS Gateway transmits all RDP traffic (that typically would have been sent over port 3389) to port 443 by using an HTTPS tunnel. This also means that all traffic between the client and TS Gateway is encrypted while in transit over the Internet.

See Terminal Services Gateway (TS Gateway)

•Terminal Services Remote App

main benefit:

Users can run programs from a terminal server and have the same experience as if the programs were running on the end user's local computer, including resizable windows, drag-and-drop support between multiple monitors, and notification icons in the notification area

See Terminal Services RemoteApp (TS RemoteApp)

What are the pros/cons of each, especially from a security standpoint?

Each of these technologies provides different functionality so it depends on your business requirement. They don't compete so it's not a this or that choice, you could implement them all if you have the need for the functionality provided. Security wise all of these technologies are or can be encrypted.

If I just connect to a remote server over port 3389 using my Remote Desktop Client, what is Microsoft-speak for that?

Remote desktop

Does it fit into any of the above categorizations?

Only in the context that it's a remote connection, if you wanted to connect over the internet than you would also use TS gateway, or web access depending on how you wanted to present the connection.

Is the main draw of TS Web Access versus a direct connection using RDC over 3389 just that one can use TLS encryption while the other uses RC4?

RDP can be encrypted via TLS see Configure Server Authentication and Encryption Levels ,so the draw of web access is ...(wait for it)... web access. You still need the client installed, but with web access I can give you a secure webpage of links to connect to either a full desktop or just a remoteapp. Note that remote desktop alone will only give you a full desktop.