Environment
NetIQ Secure Configuration Manager
Situation
Installation of SCM database on SQL server node with 'Windows only' authentication mode allows install to complete normally
Error logging into SCM console 'VigilEntService account is not associated with a trusted sql server connection'
VigilEntService account was missing Db_ddladmin and VigilEntUserAccess roles as roles hadn't been created.
VigilEntUserAccess role not created
Prerequisites do not currently specify this as a requirement.
Error logging into SCM console 'VigilEntService account is not associated with a trusted sql server connection'
VigilEntService account was missing Db_ddladmin and VigilEntUserAccess roles as roles hadn't been created.
VigilEntUserAccess role not created
Prerequisites do not currently specify this as a requirement.
Resolution
Turn on mixed mode authentication
Start Microsoft SQL Server Studio Manager -> browse to the server node where you plan to install the VigilEnt database on
Right click and select the option Properties -> Go to the Security tab and select 'SQL Server and Windows' option for Authentication.
Cause
'Windows only' authentication is set on SQL server node where SCM VigilEnt database is installed
Additional Information
Formerly known as NETIQKB70790