Microsoft KB Archive/221528

= BUG: Task Management in Enterprise Manager Uses Case Sensitive Login =

Article ID: 221528

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q221528



BUG #: 18645, 17986 (SQLBUG_65)



SYMPTOMS
When a case-insensitive SQL Server is registered in SQL Enterprise Manager with standard security using a login name with a different character case than the actual login in master..syslogins, all task management through Enterprise Manager other than 'add task' is disabled.



WORKAROUND
To work around this problem, reregister the server using the login name that matches the entry in master..syslogins.



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



MORE INFORMATION
For example, if a login is created as 'ABC' and the server is registered in Enterprise Manager as 'abc', task management will be disabled.

On a case-insensitive server, executing "select suser_name" will return the same result regardless of the character case used in the login when registering the server.

All task-related stored procedures work as expected.

Note that this bug does not apply to the system administrator (sa) login.

Additional query words: ent man entman

Keywords: kbbug kbpending KB221528

-

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

© Microsoft Corporation. All rights reserved.