I have a SQL 2000 and a SQL 6.5 server that need to be able to issue RPCs to each other.
I have followed the following steps on each:
1)Create a suitable SQL login for all remote logins to use
2)Added the other server under Client Network utility (using Named Pipes)
3)Added the other server as a remote server and configured SQL to map all remote logins to newly created one above.
Now, I'm trying to test RPC connectivity by enterring XXX...sp_who only I get an error informing that the server isn't configured for remote logins, even though it clearly is!!!