BUG: Task Management in Enterprise Manager Uses Case Sensitive Login

ID: Q221528

The information in this article applies to:

Microsoft SQL Server version 6.5

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 version 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          : SSrvEntMan kbbug6.50 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: March 20, 1999