Enable MS-SQL Windows authentication

This section describes how to configure an MS-SQL database with Windows authentication.

Note: The procedure below requires you to make changes to the MS-SQL database. We recommend that you make these changes using the SQL Server Management Studio tool.

To enable Windows authentication:

  1. Verify that the OpenText Enterprise Performance Engineering server and database server all belong to the same domain, and that there is a domain user with administrator permissions common to all the machines.

  2. Change users to domain users using the System Identity Utility. For details, see Change the system user.

  3. Download the SQL Server Management Studio tool from the Microsoft Download Center.

  4. In SQL Server Management Studio, perform the following actions:

    1. In the Object Explorer pane, expand the Security folder.

    2. Right-click Logins and select New Login.

    3. Enter the domain user in the Login name box, and make sure that Windows Authentication is selected.

      Note: Verify that the domain user is assigned the same Server Roles as the database administrative user (td_db_admin).

  5. Make sure that the relevant project is created in Administration with the MS-SQL (Win Auth) database type.