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
When users install eSight, a message is displayed indicating that connection to the SQL server database fails.
Common Causes
- The SQL server database is not enabled.
- The IP connection mode is disabled on the SQL server database.
Procedure
- 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.
- 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.
- Configure the SQL server.
- Choose Start > Microsoft SQL Server 2012 > SQL Server Configuration Manager.
The SQL Server Configuration Manager window is displayed.
- Choose SQL Server Network Configuration > Protocols for MSSQLSERVER, right-click TCP/IP, and choose Enable.
- Right-click TCP/IP and choose Properties from the shortcut menu. In the TCP/IP Properties window that is displayed, configure the SQL network.
- On the Protocol tab page, set Listen All to No.
- 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.
- Click OK.
- On the Protocol tab page, set Listen All to No.
- Restart the SQL Server database service to make the configuration take effect.
- Choose Start > Microsoft SQL Server 2012 > SQL Server Configuration Manager.
- Re-install eSight.
