数据库MSSQL连接中的三个最罕见毛病（国外英文资料）.docVIP

数据库MSSQL连接中的三个最常见错误（国外英文资料） SQL Server does not exist or access is rejected This is the most complex of all, and there are more reasons for the errors to occur, and there is more to check. In general, there are several possibilities: The SQL Server name or IP address is misspelled 2, the server-side network is configured incorrectly The client network is configured incorrectly To solve this problem, we generally follow these steps to find out what causes the error. First of all, check the network physical connection = = = Ping server IP address/server name If ping server IP address is not successful, it means that there is a problem with the physical connection, when you check the hardware device, such as network card, HUB, router, etc. Another may be due to install a firewall between the client and Server software, such as the ISA Server firewall software may be blocking the ping, Telnet, etc So when checking for connection problems, we should first turn off the firewall software or open all the closed ports. If ping server IP address is successful, ping server name fails The name resolution is a problem, and its time to check whether the DNS service is normal. Sometimes the client and the server is not in the same local area network (LAN), then it is unlikely to directly use the server name to identify the server, then we can use the HOSTS file for name resolution, The specific approach is: Use notepad to open the HOSTS file (typically in C: \ WINNT \ system32 \ drivers \ etc). Add an IP address to the corresponding record of the server name, such as: 172.168.10.24 myserver Configure the SQL Servers client network utility, which will be detailed later. For example, you can use Telnet to check the state of the SQL Server Server Telnet server IP address 1433 If the command is successful, you can see the screen flash after the cursor in the upper left corner kept flashing, suggesting that the SQL Server Server works well, and the TCP/IP connection is liste