SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
SQLisAwE5OmE
SQLisAwE5OmE
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2948 Visits: 3075
Hi All,

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

Regards,
SueTons.

Regards,
SQLisAwe5oMe.
GSquared
GSquared
SSC Guru
SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)

Group: General Forum Members
Points: 55881 Visits: 9730
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
SQLisAwE5OmE
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2948 Visits: 3075
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
AndrewSQLDBA
SSCarpal Tunnel
SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

Group: General Forum Members
Points: 4298 Visits: 3427
Same way you would Cut, Copy and Paste any where else:
Ctrl + X
Ctrl + C
Ctrl + V

Andrew SQLDBA
SQLisAwE5OmE
SQLisAwE5OmE
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2948 Visits: 3075
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
Lowell
SSC Guru
SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)

Group: General Forum Members
Points: 69240 Visits: 40917
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!
Attachments
rdp_options.png (416 views, 60.00 KB)
SQLisAwE5OmE
SQLisAwE5OmE
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2948 Visits: 3075
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
SQLisAwE5OmE
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2948 Visits: 3075
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
SQLRNNR
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64785 Visits: 18570
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

Gianluca Sartori
Gianluca Sartori
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23191 Visits: 13362
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

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search