Archive

Archive for November, 2012

Deleting a remote server deletes all remote logins defined for that server — how to delete linked server

November 7, 2012 1 comment

Problem:

while deleting a linked server in SQL server instance VIA SSMS or using command

exec sp_dropserver ‘TESTserver’

Msg 15190, Level 16, State 1, Procedure sp_dropserver, Line 44
There are still remote logins for the server ‘TESTserver”.

GUI
TITLE: Microsoft SQL Server Management Studio
——————————

Deleting a remote server deletes all remote logins defined for that server. Are you sure you want to delete this linked server and all remote logins defined for this server?

——————————
BUTTONS:

&Yes
&No
——————————

Solution ::

1> The message is a bit misleading

2> it refers  to the mapping between local and remote login .. that will be dropped (local to remote login mappings)

3> no remote logins are dropped when you drop a linked server ,,, basically the mapping at security levels are dropped

so NO worries .. whether any login will be dropped .. if you proceeded .. with YES .. on the prompt window

Enjoy 🙂

Advertisements
Categories: General