Environment
NetIQ AppManager 6.x
NetIQ AppManager 7.0.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?
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:
- Start SQL Enterprise Manager.
- Connect to the AppManager Repository (QDB by default).
- Right-click on the SQL Server where the QDB is located and select Properties.
- Click the Security tab.
- Select SQL Server and Windows under the Authentication option.
- Click OK to accept the setting.
- Close the Properties window.
- Start the Services application in Control Panel. (If using Windows 2000 or higher, the Services application is located in Administrative Tools.)
- Restart the MSSQL Server service.
- Second, verify the NT user account is setup and the Probe account is available:
- From SQL Enterprise Manager, select Security > Logins.
- Right-click on Logins and select the New Logins option.
- When the Login Setup window is displayed, click the button next to Name and select your Domain Name or Group Name.
- Ensure Windows Authentication is selected, then select QDB for the database.
- Click the database Access tab and select QDB.
- Click OK to close all windows and go back to the SQL Enterprise Administrator window.
- Expand the Databases folder, then expand QDB > Users to make sure the NT user account you just added to SQL is specified.
- 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.
- Close SQL Enterprise Manager.
- Start the AppManager Operator Console and log in as an AppManager Administrator.
- Select the Extensions > Security Manager from the console menu.
- When Security Manager starts, select AppManager Users.
- Right-click on AppManager Users and select User Setup.
- The AppManager User Setup window is displayed. Select the user account that you set up in SQL Enterprise Manager and click Add.
- Click OK to exist the console.
- Log in to the server with the specified user account and start the AppManager Console.
- Select Windows NT authentication at logon.
Additional Information
Formerly known as NETIQKB44202