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

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

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
  1. August 3, 2013 at 11:55 pm

    After checking out a number of the articles on your web site, I truly like your technique of blogging.
    I bookmarked it to my bookmark site list and will be checking back in the near
    future. Take a look at my website as well and let me know your opinion.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: