Resolution
fact
Security Manager 5.5
symptom
Security Manager 5.5 upgrade fails when LMConsole is the owner of any databases.
symptom
symptom
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.
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