远程连接执行Transact-SQL语句或批处理时发生了异常

Question

远程连接数据库时发生

无法为此请求检索数据
其他信息
执行Transact-SQL语句或批处理时发生了异常。(Microsoft.SqlServer.ConnectionInfo)
在从服务器接收结果时发生传输级错误。(provider:TCP提供程序,error:0-指定的网络名不再可用。)(Micorsoft SQL Server,错误：64)

如何解决？

Answer 1

Via linked server? Linked to another sql server? Do you use 4 part name or openquery?

Answer 2

Via linked server? Linked to another sql server? Do you use 4 part name or openquery?

Answer 3

是连接到其他的sql server，远程一个服务器

Answer 4

Any other details?

Answer 5

我与一个远程服务器的数据库进行连接操作，与服务器连接成功了，展开数据库时出现了上述错误

Answer 6

Again, connect via linked server? Do you use 4 part name or openquery? Possible to post query?

Answer 7

用sql server 2005，在management studio中建立的连接，What means 4 part name and openquery?

Answer 8

Ok, what did you do in ssms that caused error? Connect with instance name or ip address/port number? Use named pipes or tcp/ip protocol?

Answer 9

打开SMSS后输入域名和服务器分配的用户名、密码进行的连接，然后双击数据库，出现的error，用的是tcp/id and named pipes 

Answer 10

Is sql instance name correct? Use windows or sql authentication? Windows authentication doesn't need password while sql authentication doesn't ask domain name.

Answer 11

有没有使用链接服务器之类的呀，