You can also use SQL authentication for communication between the console and the database. SQL authentication creates a user ID and password that are valid only for SQL Server. For more information about authentication, see the Authentication article in the SQL Server Books Online, which are delivered with the full version of SQL Server.
To set up SQL authentication:
Set up the database in mixed-mode security in SQL Server Enterprise Manager. For more information, see the Microsoft SQL Server documentation.
On the Core Services computer, complete the following steps:
Start the Core Services Configuration Utility in the NetIQ Secure Configuration Manager program folder.
On the Database tab, set the Allow SQL Authentication field to True.
Click OK to save the changes and close the Configuration Utility.
Restart Core Services using the Windows Services utility. You can access the Windows Services utility through Control Panel.
Enable SQL authentication in Secure Configuration Manager by completing the following steps:
Start Secure Configuration Manager in the NetIQ Secure Configuration Manager program folder.
On the console login window, click Configure.
Select the Enable SQL Authentication check box.
Click OK.
Specify your user name and password and click OK.