We have a remote connect to Microsoft SQL Server studio, there are 4 remote connections we could get assigned. Now on 2 of these servers, it allows us to copy and paste the results(grid) to excel. However, on the other 2 servers, it won't allow us to copy/paste at all.
Is there permissions within the database that would stop us or is it down to the remote connection?
Use Task Manager to 'End task' on rdpclip.exe on the remote machine.
Then restart it using a Command Prompt by typing
rdpclip