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


The information in this article applies to:

  • Microsoft SQL Server 7.0
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.
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug kbDSupport KB281203
©2002 Microsoft Corporation. All rights reserved.