How to copy and paste from a RDP session to your Local Desktop

Question

How to copy and paste from a RDP session to your Local Desktop

SQLisAwe5oMe

SSChampion

Points: 14047
More actions
January 2, 2013 at 1:54 pm

#266720

Hi All,
Is there any way to copy and paste from vpn session to our host session? Please advise.
Regards,
SueTons.
Regards,
SQLisAwe5oMe.

Viewing 13 posts - 1 through 12 (of 12 total)

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

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

SQLisAwe5oMe SSChampion Points: 14047 More actions · Answer 2

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.

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 3

Same way you would Cut, Copy and Paste any where else:

Ctrl + X

Ctrl + C

Ctrl + V

Andrew SQLDBA

SQLisAwe5oMe SSChampion Points: 14047 More actions · Answer 4

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.

Lowell SSC Guru Points: 323504 More actions · Answer 5

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

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

SQLisAwe5oMe SSChampion Points: 14047 More actions · Answer 6

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.

SQLisAwe5oMe SSChampion Points: 14047 More actions · Answer 7

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.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

spaghettidba SSC Guru Points: 105732 More actions · Answer 9

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[/url], which is basically a sort of "private" pastebin.

Hope this helps

Gianluca

-- Gianluca Sartori

SQLisAwe5oMe SSChampion Points: 14047 More actions · Answer 10

Thanks for all your inputs.....I was thinking it is some type of policy settings.

Thanks again.

SueTons.

Regards,
SQLisAwe5oMe.

GSquared SSC Guru Points: 260824 More actions · Answer 11

Try copying from server to workstation, then from workstation to laptop. You might be getting a Kerberos issue with copying from the server (2-steps) to the laptop. Not sure, but it's worth a shot.

- 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

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 12

I think Gianluca hit the nail on the head there. The AD administrators could have a GPO in place which is overriding your RDP preferences. We do this where I work regardless of whether or not you are connected via a VPN or not. It is endlessly frustrating.

You would need to get the group policy changed for you to be able to do it.

Joie Andrew
"Since 1982"