Try to solve "failed to connect to U8 database server"

When debugging the U8 client today, the database connection fails. The following figure shows the problem:

650) this. width = 650; "title =" image002.jpg "src =" http://www.bkjia.com/uploads/allimg/131227/1623022227-0.jpg "alt =" 1110800002.jpg"/>

Before you start troubleshooting, check the network environment. The U8 version is V11.1, the server configuration environment is windows2008R2, the database is SQLserver2005, and the operating system installed on the client is win7 Professional Edition, the IP address of the database server is 192.168.1.100, and the server name is ERPSQLV11.

Check the setting options according to the information prompts.

1. Check the firewall database port. The default port 1433 of the database is enabled on both the server and client.

2. The database server IP address and computer name are added to the hosts file on the client and server.

3. Check the data source. On the server side, open the U8 Application Server Configuration tool-database server, and test the connection.

650) this. width = 650; "title =" image004.jpg "src =" http://www.bkjia.com/uploads/allimg/131227/1623024945-1.jpg "alt =" 114325317.jpg"/>

The three items in the Information prompt are all checked. The fault persists, and the firewall on the server and client is disabled. The fault persists, and the problem is hard to understand. It seems that it has nothing to do with the firewall and data source.

I don't know what it means. I don't know Baidu. There are a lot of search results, and the solution is similar to the above items. One of them is solved after the database port is modified, but the database of other people uses SQLsever2000SP4, is my problem here? Find [SQLserverconfigurationmanager] in the Start Menu, expand the directory menu in the left-side window, find the SQLServer2005 network configuration-MSSQLSERVER protocol, and open the total TCP/IP protocol attribute in the right-side window, the port is still 1433, but the status is disabled.

650) this. width = 650; "title =" image006.jpg "src =" http://www.bkjia.com/uploads/allimg/131227/1623025349-2.jpg "alt =" 114343828.jpg"/>

Return to the client for login verification. The problem is solved successfully.

This article from the "Sun Village Chief" blog, please be sure to keep this source http://xiaosuncunzhang.blog.51cto.com/317407/1300986