Editing USers in Enterprise Manager

Help!
We use application scripts to set up and modify users in
SQL. We are using SQL and Windows authentication. Very
occasionally, a script will fail and I will have to go in
and modify a user account directly from EM. I have done
this many times over the last 18 months and never had an
issue with it. I use the SQL Server Login Properties
dialogue box accessed from Security/Logins in EM.
Today, after I had made my changes and clicked okay, I was
immediately prompted with the "Confirm Password Change"
box. I double and triple checked (by re-executing the
task) that I had NOT in fact changed the password; I still
get the warning box. Even when I enter the CORRECT
password for the user, SQL EM warns me that the passwords
do not match and refuses to update the user account.
When I deliberately change the password and confirm the
change at the prompt, then EM accepts the changes and
proceeds.
What's going on? I tested this on three identically
configured servers and had the same results each time.
I am running:
1. SQL Server 2000 (SP3, with the latest security patch
released in July)
2. Windows 2000 Server (SP4, with the latest security
patches release in July)
3. I tested and found the problem with both Developer
Edition and Enterprise edition SQL Server.
The work-around that I have found was to go into the
Logins section for the database and make the updates
there. Note, however, that I cannot edit certain server-
wide roles in that section.
Regards,
Hugh ScottFIX: You Are Prompted for Password Confirmation After You Change a Standard
SQL Server Login
http://support.microsoft.com/?kbid=826161
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hugh Scott" <hugh.scott@.exel.com> wrote in message
news:05e901c365ce$7ef1a5a0$a101280a@.phx.gbl...
Help!
We use application scripts to set up and modify users in
SQL. We are using SQL and Windows authentication. Very
occasionally, a script will fail and I will have to go in
and modify a user account directly from EM. I have done
this many times over the last 18 months and never had an
issue with it. I use the SQL Server Login Properties
dialogue box accessed from Security/Logins in EM.
Today, after I had made my changes and clicked okay, I was
immediately prompted with the "Confirm Password Change"
box. I double and triple checked (by re-executing the
task) that I had NOT in fact changed the password; I still
get the warning box. Even when I enter the CORRECT
password for the user, SQL EM warns me that the passwords
do not match and refuses to update the user account.
When I deliberately change the password and confirm the
change at the prompt, then EM accepts the changes and
proceeds.
What's going on? I tested this on three identically
configured servers and had the same results each time.
I am running:
1. SQL Server 2000 (SP3, with the latest security patch
released in July)
2. Windows 2000 Server (SP4, with the latest security
patches release in July)
3. I tested and found the problem with both Developer
Edition and Enterprise edition SQL Server.
The work-around that I have found was to go into the
Logins section for the database and make the updates
there. Note, however, that I cannot edit certain server-
wide roles in that section.
Regards,
Hugh Scott