| Author |
Topic |
|
spookydermot
Starting Member
4 Posts |
 Posted - 2006-04-27 : 11:31:52
|
| hi folks,has anyone experienced this issue?When one changes the login password for XP, all the SQL Server groups are removed the next time you log into SQL Server 2000.Is this a bug or a security feature, is there any way around it?thanks for any help! |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-04-27 : 12:12:11
|
| Hmmm...Not sure what you mean by "SQL Server groups". Can you be morespecific? |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-04-27 : 13:13:43
|
| Welcome to SQLTeam.Are you sure they are removed or you cant log into them ???you probably choose windows authentication during install, next time choose mixed mode. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-04-27 : 16:19:17
|
| Do you mean the SQL Server groups in Enterprise Manager??Are you logging in with the same account before and after? What service pack are you on?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-28 : 02:46:07
|
| i'm guessing...the registration/enumeration of sql servers and groups are dependent on the account that logs into the machine,it's part of the user profile--------------------keeping it simple... |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-04-28 : 03:47:29
|
| If you're talking about the registration of servers in Enterprise manager being different for each login, you could try the tools -> options "read store user independant" checkbox.-------Moo. :) |
|
|
|
spookydermot
Starting Member
4 Posts |
Posted - 2006-04-28 : 06:31:15
|
| thanks for all the replies!I really appreciate itI'm sorry for not being more specific what I should have said was:In the Enterprise manager, Under the 'console root' there is 'Microsoft SQL Servers' and then there is an 'SQL Server Group', and under this group is all the different servers that I connect to.When I change my network password to log into XP (as we have to every so often) - the next time I log into the enterprise manager, I have to re-register all the servers.So it's a case that they have dissappeared.Our management console is on service pack 4Is there anyway of checing what mode I instaleld my SQL Server in (i.e 'mixed mode' or 'windows authentication') as some of you have suggested?thanks again for the replies! |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-04-28 : 07:07:54
|
| Are you changing the password or the login? There's no reason why the registrations should vanish if you change your password.-------Moo. :) |
|
|
|
spookydermot
Starting Member
4 Posts |
Posted - 2006-04-28 : 07:22:56
|
| I'm just changing the password, not the username |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-28 : 09:10:12
|
| "Is there anyway of checing what mode I instaleld my SQL Server in"Enterprise Manager : RightClick the Server : Properties : [Security]One will be checked of:"SQL Server and Window" = mixed mode"Windows only" = windows authenticationDon't change it willy-nilly though!Kristen |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-04-28 : 10:29:48
|
| Is this when you are forced to change the XP Password? We have the same problem and can't work out why it is happening, the best we could come up with is that when you are forced to change the password, the registry keys are overwritten.. The way we get around this is by changing the passwords ourselves before the expiration.. |
|
|
|
spookydermot
Starting Member
4 Posts |
Posted - 2006-05-02 : 06:09:24
|
| looks like this is the issue@:http://support.microsoft.com/kb/323280/en-us |
|
|
|
|
changing XP password affects SQL server?