Today’s article is not related to SQL Server 100%, however it is quite related to SQL Server, or atleast I found it while working with SQL Server. Just two days ago, while I was working with remote SQL Server using Remote Desktop tool provided by Windows XP. Suddenly, copy/paste feature of windows stop working on remote desktop. I was not able to copy from local machine to remote machine and remote machine to local machine, both ways. I was able to copy/paste from remote machine to remote machine and local machine to local machine.
I thought may be if I restart both the computers it will work (Do not restart your live servers in any case, also restarting is not the solution please read the solution at the end of article). It did not work. I played with few administrative services, again no luck. I was very frustrated for two days as it was very inconvenient to copy/paste and I did not had solution.
After playing with different services and process for a while I found following solution. The solution works perfectly.
First of all go to task manager in remote machine. Go to processes and kill process rdpclip.exe.
After that to go Start >> Run >> type rdpclip.exe and press OK.
This will fix your remote desktop copy/paste issue.
If you want to share files across remote desktop. Follow following instructions.
Go to Remote Desktop Connections >> Options >> Local Resources >> Local Devices >> Turn on Checkbox of Disk drives and click Connect.
I hope today’s article will help users who are facing this problem.
Reference : Pinal Dave (http://www.SQLAuthority.com)
60 Comments. Leave new
I’ve seen this same solution posted on other sites and it does not work for me. It might work for a few minutes but then copy/paste stops working again. It’s driving me nuts, driving me to consider switching to a Mac. Copy/Paste is perhaps the main reason we switched from typewriters to computers in the 1980s. Now Microsoft has found a way to make that not work. What’s next, ctrl-z will stop working?
Does anyone know if Microsoft fixed this bug in Windows 7?
Thanks for this; suddenly my copy & paste function was hanged and google helped me to find this article and you helped me to fix my problem. Thanks again.
Thank you for taking the time to research this and posting a solution.
Thanks for posting this solution
Thanks, it worked perfectly. I still have a problem connecting to local resources through Remote Desktop but copy and pasting files is an adequate work around.
Thanks for the help fixing my RDP issue with clipboard that suddently stopped working :D
I ran into this issue all the time, and finally decided to try Google; this was the first hit and it completely solved the issue. Thanks for sharing!
Thought I would chime in again to say that my issues were solved with Windows 7 Pro. I installed it a few weeks ago and the copy/paste issue has gone away completely.
I’m loving Windows 7 so far.
I am having a problem with Win 7 when I try to copy from remote connection and paste into a page open on the local computer. But I do not have this problem when I try the same thing using my older local computer operating with Win XP.
None of the solutions proposed on the internet worked for me, so I tried to log off the remote machine, but it wanted to close my program (which is R) and started the countdown “ending in 30 sec” (or smth) so I canceled.
And then it worked…
I guess when it’s preparing to close the session it clears the stuff that you want fixed :). Pretty technical I know :).
Thanks for this solution! It was indeed very frustrating to have the copy-paste stop working
Thanks, this was driving me nuts!
It worked for me. Thax.
This is an excellent post. I spent hours trying to figure this thing out and finally found your post.
thank you.
Thank you for the useful info, I saved valuable time from your post. Prosperity.
1) When you first run Remote Desktop Connection, go to options, then the Local Resources tab, and then make sure Clipboard is checked.
2) Second, create a batch file on the remote machine as follows:
c:windowssystem32TaskKill.exe /im c:windowssystem32rdpclip.exe
c:windowssystem32rdpclip.exe
3) Then create a shortcut to the batch file.
Whenever the cut and paste stops working, just click on that shortcut, and you should be functional again.
Thank you for this post, this issue has been driving me crazy. Another workaround for us (Windows 7 clients with Windows 2008 servers) is to turn off the Clipboard on the Remote Desktop client options (under Local Resources).
It worked perfectly for me…..this issue is pain in the ass…thanks for sharing
Thanks for this!!!
Legend! Thank you!