Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Unable to install or upgrade Deep Security Manager (DSM) to version 10.3 when using domain user to login to MS SQL server

    • Updated:
    • 28 Mar 2018
    • Product/Version:
    • Deep Security 10.3
    • Platform:
    • Windows 2008 Server R2 Enterprise
    • Windows 2012 Enterprise R2
Summary

Installing or upgrading to Deep Security Manager 10.3 may fail and one of the following errors may appear:

  • The database could not be read. Please check your database connection settings and network connectivity.
    Domain authentication requires that you configure both the Deep Security Manager server's operating system and domain controller, too.

    The database could not be read

  • Unable to connect to the database. An unexpected error has occurred. Please try again later. If the issue persists, contact your support provider. Integrated authentication failed. ClientConnectionID: <id_number>

    Unable to connect to the database

Details
Public

The error message shows when using domain user to login to the Microsoft SQL Server during installation or upgrade. Below are the workarounds to prevent the error.

Installation

When installing a new Deep Security Manager 10.3, do the following:

  1. Specify the SQL server's FQDN hostname on the Hostname field.
  2. Click Advanced button.
  3. On the SQL Server Advanced Options window, specify the FQDN domain on the Domain field.

    Define the FQDN Hostname

Upgrade

When upgrading to Deep Security Manager 10.3, do the following:

  1. Before upgrading, set the following parameters in C:\Program Files\Trend Micro\Deep Security Manager\webclient\webapps\ROOT\WEB-INF\dsm.properties file:

    database.SqlServer.server=<sql_server_fqdn_hostname>
    database.SqlServer.domain=<domain_fqdn>

    Below is an example:

    database.SqlServer.server=WIN-8C72DBHR866.euct4.local
    database.SqlServer.domain=euct4.local

  2. Run the Deep Security Manager 10.3 installer.
  3. Choose Upgrade when prompted.
Premium
Internal
Rating:
Category:
Troubleshoot; Install
Solution Id:
1119584
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.