April 11, 2008 at 10:08 am
Hi folks,
I have both 2005 and 2000. Now I need to use tables in 2000 when I am in 2005, I have done these on 2005 server:
EXEC sp_addlinkedserver @server='server2000',
@srvproduct='',
@provider='SQLNCLI',
@datasrc='server2000',--the data source
@provstr='Integrated Security=SSPI';
EXEC sp_addlinkedsrvlogin 'server2000', 'false', 'Domain\RXie', 'rxie', 'Password'
(I also tried:
EXEC sp_addlinkedsrvlogin 'server2000', 'true')
and then I tried this query:
select * from server2000.northwind.dbo.customers
Unluckily, it returns:
OLE DB provider "SQLNCLI" for linked server "server2000" returned message "Communication link failure".
Msg 10054, Level 16, State 1, Line 0
TCP Provider: An existing connection was forcibly closed by the remote host.
Msg 18452, Level 14, State 1, Line 0
Login failed for user 'rxie'. Reason: Not associated with a trusted SQL Server connection.
I have done lots of search with no good luck, can anyone help me out?
Thanks lots.
I have no problem linking 2005 into 2000.
April 11, 2008 at 10:34 am
If you are using Windows auth., switch to SQL authentication instead. This is the (in)famous double-hop authentication problem, whose resolution still evades me. If you RDP to the originating server and attempt to view the linked server, you will probably have no issues at all. However, if you attempt to access the linked server from your local machine, it's a double hop, and you need to configure Kerberos delegation to make it work.
I'll dig up some more info on this for you.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 11, 2008 at 7:14 pm
Up ...
April 13, 2008 at 7:54 pm
up........
April 14, 2008 at 10:13 am
Check out Brian's response, posted on 3/26/2008 11:46 AM, at
http://www.sqlservercentral.com/Forums/Topic471172-359-1.aspx
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply