| Author |
Topic |
|
hyefive
Starting Member
16 Posts |
 Posted - 2005-03-31 : 20:35:52
|
| Hi,Can someone tell me how an extra couple hundred Logins came to arrive in the Security section of my SQL Server (7.0)?This is a small-time (basically dev) server, and should only contain a few Logins and now there are massive numbers of Logins there.Is it somehow linked to another Server in my EM? They do seem to replicate those listed in one of my other Registrations...Thanks,Lost |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-31 : 20:48:08
|
| Well, how many people do you have with admin or security admin rights on the server? Anyone who has those rights could easily create the logins.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-03-31 : 21:09:37
|
| Sounds like "password" for the SA password wasn't a good idea.CODO ERGO SUM |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-03-31 : 21:14:17
|
| LOL Michael!My guess is, you have transferred a database to your local box with the "Copy Login" option checked. Now you have all the login names for the remote (isp ? ) server.DamianIta erat quando hic adveni. |
|
|
|
hyefive
Starting Member
16 Posts |
Posted - 2005-03-31 : 21:26:30
|
| I think what happened was during DTS I must've checked 'Copy Logins'... |
|
|
|
hyefive
Starting Member
16 Posts |
Posted - 2005-03-31 : 21:28:05
|
| Suggestions on the best way to get rid of them?(Yikes) |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-03-31 : 21:30:07
|
| Delete button ?DamianIta erat quando hic adveni. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-31 : 21:34:26
|
| Do you have the correct logins backed up? How do you know what to get rid of and what to keep?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
hyefive
Starting Member
16 Posts |
Posted - 2005-03-31 : 21:46:52
|
| Not backed up, but only need two of them... |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-04-01 : 02:59:17
|
| Delete the others then.You can shift-delete in EM I think.-------Moo. :) |
|
|
|
|
Mystery Logins