Microsoft SQL Server复制粘贴结果到Excel无法正常工作

问题描述:

我们有一个到Microsoft SQL Server studio的远程连接,我们可以分配4个远程连接.现在,在其中两台服务器上,它使我们能够将结果(网格)复制并粘贴到excel.但是,在其他2台服务器上,它根本不允许我们复制/粘贴.

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?

使用任务管理器在远程计算机上的rdpclip.exe上结束任务".

Use Task Manager to 'End task' on rdpclip.exe on the remote machine.

然后通过键入 rdpclip