Linked server question. - 11-15-2011 , 03:24 PM
I am not sure where to put this, so I just chose two newsgroups with hopes
it fits. My problem is this:
I have about 10 SQL2000 servers. I have this working (properly working
linked servers) on about half of them now, but I ran into this.
I have two SQL2000 servers, ServerA and ServerB.
ServerA has under Enterprise management, both information from ServerA and
ServerB. On ServerB there is only information for
ServerB. (ServerB is just a test machine for the for the application, I
don't think any of this matters, I am only mentioning this portion
because this happens to not work on only these two machines)
I added SQL2005 server to the linked server in both ServerA and and ServerB.
SQL 2005 shows up in the linked servers area of them both. I can actually
see the tables and views in the linked servers area on both ServerA and
ServerB (I have data access temporarily enabled for testing purposes.) But
when I run query analyzer (for a simple test query) on both ServerA and
ServerB, it fails and returns this.
Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'Server_2005' in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
But I did execute just like I did on the other servers and it shows up like
the others (that work properly). I am using the linked servers to utilize
a 2005 machines dbmail on Server2000.
I also opened up the tables on a failing 2000 machine and a 2000 machine
that works and checked the sysservers tables on both and they are identical.
I also have done this both ways, adding the linked servers from command line
and also through the GUI. I don't know what else to look at.
Does anyone have any ideas on this? It would be appreciated.