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

Create a technical support case if you need further support.

Unable to register Edge Relay server and Error code: 4 appears in OfficeScan (OSCE)

    • Updated:
    • 8 Nov 2017
    • Product/Version:
    • OfficeScan XG.All
    • Platform:
    • Windows 2012 Server R2
Summary

You cannot register Edge Relay server and the following error shows up:

An internal error has occurred. Restart the Edge Relay service (OfcEdgeSvc) and Microsoft Internet Information Services (IIS). Check the Edge Relay server logs for more information (Error code: 4)

Checking the event logs of the Edge server, it shows the Application Event error:

Log Name: Application  Source: MSSQL$OFCEDGE  Event ID: 18456  Computer: Trendedgerelay  Description:  Login failed for user 'sa'. Reason: Failed to open the explicitly specified database 'dbOfcEdgeMaster'[CLIENT: ].  
Details
Public

The issue is due to Edge server reinstallation. During the uninstallation, the database was not deleted and it will fail to create the db during the installation. Because of this, if you open the database using SQL Management Studio, you will not find the dbOfcEdgeMaster database.

If the same build of the Edge server is going to be used during installation, you can just attach the db:

  1. Open SQL Management Studio and connect to the SQL database.
  2. Right-click Databases, then Attach.
  3. Under databases to attach, click Add.
  4. Browse the location of the dbOfcEdgeMaster_Primary database files. The default is C:\Program Files (x86)\Microsoft SQL server\MSSQL10_10_50.OFCEDGE\MSSQL\DATA.
  5. Select the dbOfcEdgeMaster_Primary.mdf file and click OK.
  6. Restart the OfficeScan Edge Relay service.
  7. Try to register the Edge Relay server again from the OfficeScan Management console.
Premium
Internal
Rating:
Category:
Configure; Troubleshoot; Register
Solution Id:
1118711
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.