There are still remote logins or linked logins for the server

Hello Everyone,

While trying to delete linked server from SQL you might encounter the error like

There are still remote logins or linked logins for the server

Like the error says you cannot delete a linked server, until all logins associated with that linked server are removed.

So first we will have to remove those logins and than we can safely remove that linked server

To Remove logins for a specific linked server use the following query

sp_droplinkedsrvlogin 'Your Linked Server Name',null

Execute the above procedure with your linked server name and it will remove all logins associated with it.

Now try to remove the linked server by following query

sp_dropserver 'Your Linked Server Name'

That's it your have successfully deleted linked Server

I hope it was informative for you and I would like to thank you for reading.