Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

How to copy and paste from a RDP session to your Local Desktop Expand / Collapse
Author
Message
Posted Wednesday, January 2, 2013 1:54 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 10:19 PM
Points: 398, Visits: 2,421
Hi All,

Is there any way to copy and paste from vpn session to our host session? Please advise.

Regards,
SueTons.


Regards,
SQLisAwe5oMe.
Post #1402070
Posted Wednesday, January 2, 2013 2:10 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
In the RDP app, click Show Options, go to the Local Resources tab, and share the clipboard. That should do it.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1402076
Posted Wednesday, January 2, 2013 2:45 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 10:19 PM
Points: 398, Visits: 2,421
GSquared (1/2/2013)
In the RDP app, click Show Options, go to the Local Resources tab, and share the clipboard. That should do it.


Hi Gsquared,

Maybe I should have phrased differently, what I mean was, how do you copy and paste from VPN session to your host session(laptop).

For example, when you work from home using VPN connection.

SueTons.


Regards,
SQLisAwe5oMe.
Post #1402091
Posted Wednesday, January 2, 2013 3:44 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, July 17, 2014 3:19 PM
Points: 975, Visits: 3,342
Same way you would Cut, Copy and Paste any where else:
Ctrl + X
Ctrl + C
Ctrl + V

Andrew SQLDBA
Post #1402102
Posted Wednesday, January 2, 2013 3:53 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 10:19 PM
Points: 398, Visits: 2,421
AndrewSQLDBA (1/2/2013)
Same way you would Cut, Copy and Paste any where else:
Ctrl + X
Ctrl + C
Ctrl + V

Andrew SQLDBA


You sure about this?....Have you done it?....apparently, it's not working for me or I am not sure if you understood my scenario.

If you have done it, please let me know exactly how....normal ctrl x or ctrl c won't work.

Thanks,
SueTons.


Regards,
SQLisAwe5oMe.
Post #1402111
Posted Wednesday, January 2, 2013 4:04 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 12,887, Visits: 31,832
for me, a VPN session just gives me an ip and DNS services on my work LAN so i can see all the servers on the lan.
so if i open my SSMS and connect to a server on the work LAN, it's transparent and cannot affect the clipboard.

As Gsquared mentioned, if you are using an Remote Desktop Protocol connection, syncing the clipboard is an option, and as i remember it, you can only cut copy paste text, not objects or images.

are you using RDP?




Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son


  Post Attachments 
rdp_options.png (120 views, 60.51 KB)
Post #1402114
Posted Wednesday, January 2, 2013 4:34 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 10:19 PM
Points: 398, Visits: 2,421
Lowell (1/2/2013)
for me, a VPN session just gives me an ip and DNS services on my work LAN so i can see all the servers on the lan.
so if i open my SSMS and connect to a server on the work LAN, it's transparent and cannot affect the clipboard.

As Gsquared mentioned, if you are using an Remote Desktop Protocol connection, syncing the clipboard is an option, and as i remember it, you can only cut copy paste text, not objects or images.

are you using RDP?




Yes I am using RDP after I connect to my desktop using VPN connection.
My work desktop is a VDI and I don't have SSMS installed on it.....so, from my desktop I RDP to each server. So, if I am physically at work what you suggest would work for me to copy something from remote server to my desktop, however, if I am at home and using VPN connection, there is another layer there and I cannot copy anything from server to my personal laptop. Maybe, it might be company security/policy settings.

Anyway, I will try your suggestions and keep you posted.

Thanks guys,
SueTons.



Regards,
SQLisAwe5oMe.
Post #1402117
Posted Wednesday, January 2, 2013 8:52 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 10:19 PM
Points: 398, Visits: 2,421
Hi Lowell & all,

I've tried what you suggested and it does not work for my scenario. I am able to copy the data from remote server to my work desktop however, not to my laptop which I am using to connect to my work.

If anyone find any additional information, please keep me posted.

Thanks,
SueTons.


Regards,
SQLisAwe5oMe.
Post #1402158
Posted Wednesday, January 2, 2013 9:09 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:08 PM
Points: 21,231, Visits: 14,940
I have used several VPN clients and have had no issues. What VPN software are you using? Have you checked with your IT team to determine if they have something enabled in your VPN layer?



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1402162
Posted Thursday, January 3, 2013 2:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:18 AM
Points: 5,014, Visits: 10,515
It might be a policy enforced by your system administrators. It's not in the VPN, but in the RDP settings.
I'm under the same restrictions here.
I work around it using ledelog, which is basically a sort of "private" pastebin.

Hope this helps
Gianluca


--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1402250
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse