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

Create a technical support case if you need further support.

Connecting to a custom port for SQL server during database installation

    • Updated:
    • 15 Oct 2015
    • Product/Version:
    • InterScan Messaging Security Suite 7.1 Windows
    • InterScan Messaging Security Suite 7.5 Windows
    • Platform:
    • Windows 2008 Enterprise
    • Windows 2008 Standard
Summary

Configure a custom port for the SQL server because there is no option to specify one during database installation. The Control Manager (TMCM) and Interscan Messaging Security Suite (IMSS) installers connect to the SQL server on port 1433 by default.

Details
Public

On the TMCM or IMSS server, set up an alias pointing to SQL server database instance on the specified port. You must configure this in both 32-bit and 64-bit SQL Server Client Network Utility.

  1. Open the following:
    • C:\Windows\SysWOW64\cliconfg.exe
    • C:\Windows\cliconfg.exe
  2. Under General tab, add TCP/IP to the Enabled protocols by order field.
  3. Click Properties and change the value of the Default port field to the custom port used by the SQL server.
  4. Go to Alias tab, then click Add.
  5. Add a new alias in the Server alias field. Take note of this alias because you will need it during installation.
  6. In the Network libraries section, select TCP/IP radio button.
  7. In the Connection parameters section, specify the SQL server in the Server name field.
  8. Untick the Dynamically determine port check box.
  9. In the Port number field, enter the port number that SQL server is listening to.
  10. Click OK > OK. You can now specify the server alias name used in Step 5 during the production installation phase corresponding to the database.
Premium
Internal
Rating:
Category:
Configure; Deploy; Install
Solution Id:
1060438
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.


Need More Help?

Create a technical support case if you need further support.