Microsoft KB Archive/281203

= BUG: Unable to Change Password in SEM when Server is Registered with Non-SA SQL Server Login =

Article ID: 281203

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q281203



BUG #: 100832 (SQLBUG_70)



SYMPTOMS
When a SQL Server is registered in the SQL Enterprise Manager (SEM) under a non-system administrator (sa) SQL Server login account, and the account is not a member of the sysadmin and securityadmin fixed server roles, when you double-click that same login account in the Logins section of the Security folder, the properties box does not display for you to change the password. No action takes place even though the account is not dimmed.



WORKAROUND
To work around this problem, you can either:
 * Use the sp_password stored procedure from Query Analyzer to change the password.

-or-
 * Connect from a SQL Server 2000 version of SEM to the SQL Server 7.0 server.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Additional query words: Change password 7.0 enterprise manager

Keywords: kbbug kbpending KB281203

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.