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 Administration (2000)
 REMOTE STORE PROCEDURES

Author  Topic 

MarinaDavydova
Starting Member

1 Post

Posted - 2004-08-11 : 16:34:42
When I tried to call remote store procedure which locates on Ms SQL 2000 server from MS SQL 6.5 it failed with message:
Msg 18481, Level 16, State 2
Unable to connect to site ... because it is unavailable or does not exist.
Note: I added both servers to sysserver table on both sides and added logins:
sp_addserver shoufandb03
sp_addremotelogin shoufandb03,'sa','sa'

However, I can do RPC from SQL 2000 to sql6.5

Please help ASAP!!! Very critical!

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2004-08-11 : 17:38:24
Post moved to the administration forum.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page
   

- Advertisement -