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.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2013-03-18 : 16:59:47
|
| Hi,I tried to drop linked server login mentioned in linked server propeerties->security. When I clicked a login and selected delete, it process successfully. When I open again linked server properteis, this login is still there. I used both GUI and command line:sp_droplinkedsrvlogin [ @rmtsrvname= ] 'rmtsrvname' , [ @locallogin= ] 'locallogin'GO nothing works. There is no error. Any help.Thanks |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-03-21 : 08:29:01
|
| If you are no longer using this user, delete it from Main Security either. Restart the services and try to see if it still exists, sometimes it works. |
 |
|
|
|
|
|
Cannot delete linked server login