Terminal Services - A Couple Tips

Question

Terminal Services - A Couple Tips

Viewing 9 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply

RD Francis SSCarpal Tunnel Points: 4867 More actions · Answer 1

I became dependent on Terminal Services/VNC during a period when our internet connection was a bit flaky. I had several long-running jobs to execute, and running them from a local Query Analyzer session to our hosted DB server seemed to inevitably result in a broken connection partway through. I finally started running these lengthy jobs on the db server itself (don't worry, they were already tuned to provide minimal interference with the system), and saved myself a lot of frustration.

R David Francis

lila SSChasing Mays Points: 609 More actions · Answer 2

Thanks, this was really usefull! I have been using TS for a few months now, but I have just created nice little rdp's for all those servers of which I had to look up the IP's every time!

Mat Culpepper SSC Enthusiast Points: 138 More actions · Answer 3

Great article and some great tips in the comments, but we have one issue that I would like to see if anyone has any answer to....

We use Term Serv to connect to many boxes on different networks. In many cases, the firewalls between the networks only allow the ports for Term Serv. We typcially use Win2k Pro as our workstations connecting to Win2k Server and Adv Server on the other end. We need to be able to copy files occassionally and cannot find a reliable way to do this through the Term Serv connection. I know that there is an option to map drives, but this is a standard windows drive mapping that won't work across a firewall with only Term Serv ports open.

Any suggestions? We have looked at the AnalogX product TermServ copy that uses the clipboard as a temporary space to allow sending of files, but it is not quite "easy" enough for our support staff to be able to use it.

Thanks in advance

Andy Warren SSC Guru Points: 119902 More actions · Answer 4

Dont know, but I will look - I can see where it would be useful.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter

Lou Maggio SSC Rookie Points: 41 More actions · Answer 5

quote:
Lou!!! Tell me about this feature of cutting and pasting...please. I have been needing this forever and couldn't find any way to do it.
BTW, I live by Terminal Services. When our SysAdmin restores the files for a database, using Terminal Services helps me do a search across the drives to find the files I need to use to attach the database.
The Windows 2003 feature will be nice.
Michelle Morris

Andrey-162166 SSC Journeyman Points: 90 More actions · Answer 6

Andrey-162166

SSC Journeyman

Points: 90

October 14, 2004 at 3:25 am

#526672

kg/am

T hargreaves Grasshopper Points: 11 More actions · Answer 7

The w2k3 adminpack also has a useful app called remote desktop. This can be setup so you can switch between servers by selecting them from a console tree down the side of the screen.

wendyp SSC Enthusiast Points: 183 More actions · Answer 8

One word of caution -- if manually running a DTS package (for whatever reason...it happens!) make sure you don't loose your TS connection. The package will appear to continue processing, however it does not.

Thank you, school of Hard Knocks...

cytodex Old Hand Points: 337 More actions · Answer 9

Becareful with VNC, it transters data in TEXT, meaning you can be prone to sniffer and "internal" hackers.