Using Windows Authentication for SQL Server Parent topic

Trend Micro recommends using SQL Server Authentication method for SQL Server instead of Windows Authentication. However, you can also configure Windows Authentication for SQL Server.

Procedure

  1. Create a user account in Active Directory server with the Mobile Security database access rights. You may skip this step if you already have a user account with the required access rights.
    1. Create a user account in Active Directory server.
    2. Start SQL Server Management Studio and connect to the Mobile Security database.
    3. Expand the Security folder from the tree on the Object Explorer.
    4. Right-click Logins and then click New Logins.
    5. Click General from the Select a page on the left, and do the following:
      1. Type the user name that you created in Step a of this procedure in the Login name field and click Search.
        Select User or Group dialog box appears.
      2. Type the user name with the domain name (for example: domainname\username) in the Enter the object name to select field and click Check Names.
      3. Click OK.
    6. Select Server Roles from the Select a page on the left, and select the following roles:
      • public
      • sysadmin
    7. Click OK.
      The user account appears in the Logins folder on the Object Explorer.
  2. Add Mobile Security Management Server in to the same domain as Active Directory server.
  3. On the Management Server, navigate to StartAdministrator ToolsComputer Management and do the following.
    1. Expand the Local Users and Groups folder from the left tree, and then double-click Groups.
    2. Right-click Administrators and click Properties.
    3. Click Add button on the General tab, and do the following:
      1. Type the user name that you created in Step a of this procedure in the Login name field and click Search.
        Select Users, Computers, Services, Accounts, or Group dialog box appears.
      2. Type the user name with the domain name (for example: domainname\username) in the Enter the object name to select field and click Check Names.
      3. Click OK.
    4. Click OK on the Administrator Properties dialog box.
  4. On the Management Server, go to the following location:
    C:\Program Files\Trend Micro\ Mobile Security\
    or
    C:\Program Files(x86)\Trend Micro \Mobile Security\)
  5. Open TmDatabase.ini in a text editor. If the TmDatabase.ini file does not exist, create a file using text editor and name it TmDatabase.ini.
  6. Add the following text into the TmDatabase.ini file:
    ConnectionStringFormat=Provider=sqloledb;Data Source=%server%;Initial Catalog=%database%;Integrated Security=SSPI;
    TmDatabase_ini.png

    TmDatabase.ini file

  7. On the Management Server, open Windows Services, and double-click Mobile Security Management Module Service.
  8. On the Log On tab, select This account: and type the account name that will access the database, and its password in Password and Confirm password fields, and then click OK.
  9. Right-click on the Mobile Security Management Module Service in the services list, and then click Restart.
  10. Configure database settings on administration Web console:
    1. Click AdministrationDatabase Settings.
    2. Type the database server IP address, user name, password and the database name.
    3. Click Save.