There are still remote logins or linked logins for the server ‘linkedservername’

There are still remote logins or linked logins for the server ‘Linked server name’

Open SQL Server Management Studio, Run (press F5) this query SELECT * FROM sys.servers Query returns all the linked servers created
Run ( press F5) exec sp_dropserver ‘XXXX’ Replace XXXX with your linked server name which is the second column value of your step 1 query results
Run (press F5) exec sp_droplinkedsrvlogin ‘XXXX’,’YYYYY’ Replace XXXX with your linked server name which is the second column value of your step 1 query results, Replace YYYY with NULL
That’s it. Now you will not receive error .
Sample