No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

eSight V300R009C00 Local HA System Software Installation Guide (SUSE Linux + MySQL + OMMHA) 11

Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
Failure in Backing Up eSight Because the Non-default Port of the SQL Server Database Is Used

Failure in Backing Up eSight Because the Non-default Port of the SQL Server Database Is Used

Symptom

In Windows operating system, eSight uses the non-default port of the SQL Server database listener. When users attempt to back up data, a failure occurs and the illegal user or keyvalue message is displayed.

Possible Causes

When the maintenance tool attempts to connect to the database using IP address (for example, osql -S127.0.0.1 -Usa -PChangeme@@123), the default port of the SQL Server database (1433) is used. Currently, the port listened by sqlserver is not 1433. You need to manually configure sqlserver to listening on the port 1433.

Procedure

  1. Log in to the server as an administrator.
  2. Among all programs, choose Microsoft SQL Server 2012 > SQL Server Configuration Manager.
  3. In the SQL Server Configuration Manager window, choose SQL Server Network Configuration > Protocols for xxx, right-click TCP/IP, and choose Properties.

    Here, xxx indicates the name of the database instance.

  4. Find the listening address of the sqlserver process in the TCP/IP Properties window. (The listening address in the actual environment is used.) Add 1433 in the corresponding value of TCP Port and separate the port with other ports using a comma (,). Ensure that Active is set to Yes and Enabled is set to Yes. Click OK.

  5. In the SQL Server Configuration Manager window, choose SQL Server Service, right-click SQL Server Agent (xxx), and choose Restart.

    Here, xxx indicates the name of the database instance.

  6. Perform a backup again.
Download
Updated: 2019-11-22

Document ID: EDOC1100011856

Views: 94750

Downloads: 54

Average rating:
This Document Applies to these Products
Related Version
Related Documents
Share
Previous Next