Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Linked servers!

Author  Topic  Alicia Starting Member 3 Posts Posted - 2001-10-11 : 09:11:20 I am having problems setting up a liked server from one SQL7 server to another SQL7 server and then getting to the data. i have been using this to connect... EXEC sp_addlinkedserver 'ABC-01','SQL server' EXEC sp_addlinkedsrvlogin 'ABC-01', 'false', NULL, 'User','pasword' and then... SELECT * FROM OPENQUERY([ABC-01], 'SELECT * FROM TABLE1') to get data out. All i get is this message.. Server: Msg 17, Level 16, State 1, Line 1 SQL Server does not exist or access denied. Probably something obvious, but i cant see it.