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 V300R010C00 Maintenance Guide 07

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).
Connection to the SQL Server Database Fails During eSight Installation

Connection to the SQL Server Database Fails During eSight Installation

When users install eSight, a message is displayed indicating that connection to the SQL server database fails.

Common Causes

  1. The SQL server database is not enabled.
  2. The IP connection mode is disabled on the SQL server database.

Procedure

  1. Connect to the database by running a command.

    Run the Osql -Uusername -Ppassward command in the CLI. Replace username and password in the command with the correct user name and password.

    • If "no data source and no driver" is displayed, the connection fails, check that the SQL server database is enabled.
    • If "1>" is displayed, the connection succeeds, go to Step 2.

  2. Connect to the database in IP connection mode after confirming that the user name and password are correct.

    Run the Osql -Uusername -Ppassward -Sip address of SQLServer command in the CLI. The user name, password, and IP address of the server on which the database is installed depend on the actual situation.

    • If "1>" is displayed, the connection succeeds, contact the technical support personnel.
    • If "** login failed", the connection fails, go to Step 3.

  3. Configure the SQL server.

    1. Choose Start > Microsoft SQL Server 2012 > SQL Server Configuration Manager.

      The SQL Server Configuration Manager window is displayed.

    2. Choose SQL Server Network Configuration > Protocols for MSSQLSERVER, right-click TCP/IP, and choose Enable.

    3. Right-click TCP/IP and choose Properties from the shortcut menu. In the TCP/IP Properties window that is displayed, configure the SQL network.
      1. On the Protocol tab page, set Listen All to No.

      2. On the IP Addresses tab page, set Enabled to Yes for 127.0.0.1. For other IP addresses, retain the default value No for Enabled.

      3. Click OK.
    4. Restart the SQL Server database service to make the configuration take effect.

  4. Re-install eSight.
Translation
Download
Updated: 2019-06-30

Document ID: EDOC1100044373

Views: 24958

Downloads: 74

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