Using Windows Authentication for SQL Server

This section describes how to set up Service Desk and Asset Manager to use Microsoft SQL Server using Windows authentication, rather than SQL Server authentication.

Ensure you have a Windows account with enough rights to log into SQL Server.

To configure Service Desk and Asset Manager for SQL Server using Windows authentication:
  1. In the Ivanti Configuration Center, open the required instance.
  2. Alongside the Service Desk Framework application, click Edit.
    The Edit Application dialog for the Service Desk Framework appears.
  3. In the Database connection details group, select the Integrated Security check box, then click OK.
  4. Alongside the Web Access application, click Edit.
    The Edit Application dialog for Web Access appears.
  5. In the Database connection details group, select the Integrated Security check box, then click OK.
  6. Using the Configuration Center, determine the Application Pool used by ServiceDesk.Framework.
  7. Modify the Identity property of the application pool in use.
    In IIS 6, expand Application Pools, right-click the application pool found above and click Properties. On the Identity tab set the Windows user account you are using.
    In IIS 7, select Application Pools, right-click the application pool found above and click Advanced Settings. Set the Identity property to the Windows user account you are using.