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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2008-05-07 : 09:56:04
|
| Can someone remind me where Server Logins are stored in SQL Server? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-05-07 : 10:02:15
|
| master.sysxloginsHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-07 : 10:20:00
|
| Also in sys.server_principals for SQL 2005. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-07 : 11:01:25
|
| In 2005, Sysxlogins doesn't work. Need syslogins |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2008-05-08 : 03:50:45
|
| That's what I thought, so why don't I see all the logins in Studio Manager after I have restored the master db? |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-08 : 10:36:42
|
| Do you need to refresh the view? Enterprise Manager was notorious for that sort of thing. |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2008-05-08 : 10:44:00
|
| thanks, tried that though |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-08 : 10:51:22
|
| What happens when you query the sys.server_principals table directly? Do the correct logins show up there? |
|
|
|
|
|
|
Where are Server Logins stored?