Today’s article discusses a common issue that many SQL Server users encounter while working with remote desktop tools provided by Windows. Although not directly related to SQL Server, this problem often arises during SQL Server administration tasks.
Imagine you are working on a remote SQL Server using a remote desktop tool, and suddenly the copy/paste feature stops working. You find yourself unable to copy from your local machine to the remote machine, as well as from the remote machine to your local machine. Restarting both computers doesn’t solve the issue, and you start to feel frustrated.
After spending some time experimenting with different administrative services and processes, I discovered a simple solution that resolved the copy/paste problem. Here’s what you need to do:
- Open the task manager on the remote machine.
- Go to the “Processes” tab and locate the process named “rdpclip.exe”.
- End the “rdpclip.exe” process.
- Next, go to “Start” and then “Run”.
- Type “rdpclip.exe” and press “OK”.
Following these steps should fix the copy/paste issue in your remote desktop session. You will now be able to copy and paste between your local machine and the remote machine.
If you also want to share files across the remote desktop session, you can follow these additional instructions:
- Open the “Remote Desktop Connections” tool.
- Go to “Options” and then “Local Resources”.
- Under “Local Devices”, turn on the checkbox for “Disk drives”.
- Click “Connect” to establish the remote desktop connection.
I hope this article helps those who are facing the copy/paste issue in their remote desktop sessions while working with SQL Server. Remember, restarting your live servers is not a solution, and it’s always best to find a workaround like the one mentioned here.
Reference: Pinal Dave (http://www.SQLAuthority.com)