How do I change AppManager authentication to use Windows accounts? (NETIQKB44202)

  • 7744202
  • 02-Feb-2007
  • 07-Mar-2011

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

How do I change AppManager authentication to use Windows accounts?
How do I update AppManager to 'allow Windows NT authentication' when 'allow SQL authentication' was previously selected during the installation?

Resolution

To enable Windows account authentication for AppManager:

  • First, verify the SQL Server is using mixed mode authentication:
    1. Start SQL Enterprise Manager.
    2. Connect to the AppManager Repository (QDB by default).
    3. Right-click on the SQL Server where the QDB is located and select Properties.
    4. Click the Security tab.
    5. Select SQL Server and Windows under the Authentication option.
    6. Click OK to accept the setting.
    7. Close the Properties window.
    8. Start the Services application in Control Panel.  (If using Windows 2000 or higher, the Services application is located in Administrative Tools.)
    9. Restart the MSSQL Server service.

  • Second, verify the NT user account is setup and the Probe account is available:
    1. From SQL Enterprise Manager, select Security > Logins.
    2. Right-click on Logins and select the New Logins option.
    3. When the Login Setup window is displayed, click the button next to Name and select your Domain Name or Group Name.
    4. Ensure Windows Authentication is selected, then select QDB for the database.
    5. Click the database Access tab and select QDB.
    6. Click OK to close all windows and go back to the SQL Enterprise Administrator window.
    7. Expand the Databases folder, then expand QDB > Users to make sure the NT user account you just added to SQL is specified.
    8. Ensure the Probe account is specified. If it is the Probe account is not listed, repeat Steps 1 through 6 to create the account and set a blank password.
    9. Close SQL Enterprise Manager.
    10. Start the AppManager Operator Console and log in as an AppManager Administrator.
    11. Select the Extensions > Security Manager from the console menu.
    12. When Security Manager starts, select AppManager Users
    13. Right-click on AppManager Users and select User Setup.
    14. The AppManager User Setup window is displayed. Select the user account that you set up in SQL Enterprise Manager and click Add.
    15. Click OK to exist the console.
    16. Log in to the server with the specified user account and start the AppManager Console.
    17. Select Windows NT authentication at logon.

Additional Information

Formerly known as NETIQKB44202