Security Manager 5.5 upgrade fails when LMConsole is the owner of any databases. (NETIQKB52970)

  • 7752970
  • 02-Feb-2007
  • 02-Nov-2007

Resolution

fact
Security Manager 5.5

symptom
Security Manager 5.5 upgrade fails when LMConsole is the owner of any databases.

symptom

Error: 'Login 'LMConsole' owns one or more database(s). Change the owner of the following database(s) before dropping login:'



symptom

DECLARE @loginnm sysname
SET @loginnm = NULL
SELECT @loginnm = [name] FROM master.dbo.syslogins WHERE UPPER([name]) =
'LMCONSOLE'
IF @loginnm IS NOT NULL
EXEC sp_droplogin @loginnm



cause
The Security Manager setup script tries to remove the obsolete LMConsole SQL login ID Security Manager no longer uses.  If this ID owns any database, the setup script fails.

fix
To resolve this issue, please contact NetIQ Technical Support and reference this KB article.

Additional Information

Formerly known as NETIQKB52970