BUG: Task Management in Enterprise Manager Uses Case Sensitive Login

• Microsoft SQL Server version 6.5

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