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?Answer1:
Use Task Manager to 'End task' on rdpclip.exe on the remote machine.
Then restart it using a Command Prompt by typing
<a href="https://i.stack.imgur.com/VryWo.png" rel="nofollow"><img alt="enter image description here" class="b-lazy" data-src="https://i.stack.imgur.com/VryWo.png" data-original="https://i.stack.imgur.com/VryWo.png" src="https://etrip.eimg.top/images/2019/05/07/timg.gif" /></a>