由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - linked server
相关主题
扯扯Senior SQL Server DBA咋整 (开锣)create linked server problem, please help
一个数据库盲怎么学习使用SQL Server 2008?a Store Procedure question...
大俠 问个关于asp连SQL server的问题Help on SQL 2012 Add a Linked Server through ODBC
SQL SERVER moving certificate and symmetric keys between servershow to register SQL Server in intranet
有人抽取过AS/400(iSeries)的数据么?Any SSIS high hand here?
linked server problem in SQL SERver 2000, please help!!请问SQL Server2005里如何多行注释?
SQL Linked ServersSP is less performance than Direct SQL Query if using CTE?
要同时用2个不同的SQL SERVER的DATABASE,怎么办?请问怎样找到StoredProcedures的修改记录?
相关话题的讨论汇总
话题: server话题: remote话题: linked话题: sql话题: provider
进入Database版参与讨论
1 (共1页)
s****e
发帖数: 54
1
Hi,
I have 2 server, one is local one is remote.
I have no problem to use sql management studio to set up the connection.
But what I want is to create a view, this view will get the information from
a table in the remote server.
I added the remote server link.
I can run :
use localserver
select * from sys.servers where name='remote server'
but when I try this:

select * from [remote server].[remote database].[dbo].[remote table]
where UniqueID='17'
uniqueID is the column name in the remote table
I got this error:
OLE DB provider "SQLNCLI10" for linked server "remoteserver" returned
message "Login timeout expired".
OLE DB provider "SQLNCLI10" for linked server "remoteserver" returned
message "A network-related or instance-specific error has occurred while
establishing a connection to SQL Server. Server is not found or not
accessible. Check if instance name is correct and if SQL Server is
configured to allow remote connections. For more information see SQL Server
Books Online.".
Msg 1326, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [1326].
Any idea?
m*****y
发帖数: 229
2
你要有linked server才行吧。[linked server].[remote database].[dbo].[remote
table]
c*****d
发帖数: 6045
3
同意楼上说的,用这个sql确认添加了linked server
select * from sys.sysservers where isremote=0
s****e
发帖数: 54
4
I added the linked server.
the remote server is show under the SSMS, server object, linked server.
This is my first time try the linked server. I guess there is some setting
wrong.
I have no problem use object explorer to connect to the remote server.
Thanks!
s****e
发帖数: 54
5
I added the linked server.
the remote server is show under the SSMS, server object, linked server.
This is my first time try the linked server. I guess there is some setting
wrong.
I have no problem use object explorer to connect to the remote server.
Thanks!
c*****d
发帖数: 6045
6
在SSMS->server object->linked server
右键点击remote linked server->test connection
有错误信息吗
s****e
发帖数: 54
7
找到问题了
由于server name 比较复杂。所以我copy paste 的时候居然少copy 了一位
现在没问题了。
多谢各位!
c*****d
发帖数: 6045
8
不发包子不能平民愤

【在 s****e 的大作中提到】
: 找到问题了
: 由于server name 比较复杂。所以我copy paste 的时候居然少copy 了一位
: 现在没问题了。
: 多谢各位!

e****7
发帖数: 4387
9
s****e
发帖数: 54
10
baozi fa le
no money le...
1 (共1页)
进入Database版参与讨论
相关主题
请问怎样找到StoredProcedures的修改记录?有人抽取过AS/400(iSeries)的数据么?
什么也不懂,要考个SQL Server 的证linked server problem in SQL SERver 2000, please help!!
有沒有人討論一下 Query Tool?SQL Linked Servers
journal for sql server要同时用2个不同的SQL SERVER的DATABASE,怎么办?
扯扯Senior SQL Server DBA咋整 (开锣)create linked server problem, please help
一个数据库盲怎么学习使用SQL Server 2008?a Store Procedure question...
大俠 问个关于asp连SQL server的问题Help on SQL 2012 Add a Linked Server through ODBC
SQL SERVER moving certificate and symmetric keys between servershow to register SQL Server in intranet
相关话题的讨论汇总
话题: server话题: remote话题: linked话题: sql话题: provider