July 22, 2002 at 3:49 pm
I have two SQL 2000 Servers, one named DBSRVR and another named WIN2000. I used sp_addlinkedserver on each to make the necessary sysservers table entries and I can query from DBSRVR to WIN2000 but I get a 7399 error when I try to query from WIN2000 to DBSRVR. A simple query such as:select count(*) from DBSRVR.testphysinv.dbo.MAVESbak. gives me the error. The microsoft support article is:http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314530 but the workaround didn't seem to help. Any ideas??
July 22, 2002 at 4:55 pm
Havent seen this or had a problem using linked servers. Tried profiling the connection to see what happens? Maybe try openrowset? Also try selecting against something even simpler, like sysobjects in master just to see if its constant.
Andy
July 24, 2002 at 7:43 am
hi,
after sp_addlinkedserver, you must run sp_addlinkedsrvlogin
bye antonio
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply