Linked srv VS remote srv? - SQL Server Forums

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)

Linked srv VS remote srv?

Author

Topic

robg69
Starting Member

41 Posts

Posted - 2004-08-31 : 04:27:42

Hey guys,
Ok, I thought I realized the difference between "linked servers" and "remote servers", but I guess not...here is the deal: I guess I accidently made a remote server connection before I learned about linked servers. No big deal, right? Well, when I try to delete the remote server connections that I have, it gives me a error:

"Microsoft SQL-DMO (ODBC SQLState: 4200)...
Error 15190: There are still remote logins for the remote logins for the server 'xxxx'.

Now I never created users after these or have a user connected to these. I can stop the db and restart and it gives me the same error all the time. In fact, one server doesn't even exist anymore.

SO, why can I not get rid of these remote servers???

Thanks!

mr_mist
Grunnio

1870 Posts

Posted - 2004-08-31 : 05:03:14

If you double-click on the remote server, then are there entries in the "remote logins" bit at the bottom? If so, remove them.

Otherwise, try

sp_helpremotelogin [ [ @remoteserver = ] 'remoteserver' ]
[ , [ @remotename = ] 'remote_name' ]

and

sp_dropremotelogin [ @remoteserver = ] 'remoteserver'
[ , [ @loginame = ] 'login' ]
[ , [ @remotename = ] 'remote_name' ]

-------
Moo. :)

robg69
Starting Member

41 Posts

Posted - 2004-08-31 : 13:40:34

Thanks for the reply mr_mist, but that didn't work. There is no login info when I open the remote server info. And I ran the SPs and they returned the following info:

exec sp_helpremotelogin 'xxx'
exec sp_dropremotelogin 'xxx'

Server: Msg 15201, Level 16, State 1, Procedure sp_helpremotelogin, Line 20
There are no remote logins for the remote server 'xxx'.

(0 row(s) affected)

(0 row(s) affected)

Server: Msg 15021, Level 16, State 1, Procedure sp_dropremotelogin, Line 71
There are no remote users mapped to any local user from remote server 'xxx'.

Any ideas?
Thanks!

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2004-08-31 : 14:41:44

quote:
Originally posted by robg69
Now I never created users after these or have a user connected to these. I can stop the db and restart and it gives me the same error all the time. In fact, one server doesn't even exist anymore.

I wonder if this is your problem. BOL says that there are changes needed on the remote side to completely remove the remote server junk.

Here is a page from BOL http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_1_013_97ax.asp

-ec

robg69
Starting Member

41 Posts

Posted - 2004-08-31 : 15:29:32

OK, I got it. It was just a matter of figuring out which stored procedure to run. I found the following and they worked:

sp_helpserver --(REMOTE/LINKED Server List)

sp_dropserver 'xxx1', 'droplogins' --(Drop Remote Server 1)
sp_dropserver 'xxx2', 'droplogins' --(Drop Remote Server 2)

Thanks for pointing me in the right direction!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources