MS SQL Server Connectivity - Linked servers MSDE

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Linked servers MSDE

Kolar

2005-04-14, 1:23 pm

I am trying to link 2 MSDE bases.
I use mixed mode authentication, port is 850.
Linked server is done with this code on both mashines.

USE master
GO

EXEC sp_addlinkedserver
@server = 'server2',
@srvproduct = 'SQLServer OLEDB Provider',
@provider = 'SQLOLEDB',
@datasrc = 'InfoNet'

EXEC sp_addlinkedsrvlogin
'server2', 'false', 'sa', 'sa', 'secret'

but when I trie

SELECT *
FROM server2.pubs.dbo.authors

I get data from my local server, not from server2.
Any idea?

Regards

Sponsored Links