WINDOWS Server 2003 (Windows XP SP2) Access SQLServer 2000 Database (Error Establish Socket)
After the SQLServer 2000 Enterprise version is installed by default, use the JSP to call the JDBC driver to access the database, you will get the error prompt of "Error Establish Socket", that is, the driver can't find the port of SQL Server, by viewing the "Event Viewer" application event , Have the following error message:
"You run Microsoft SQL Server 2000 version or Microsoft SQL Server 2000 Desktop Engine (also known as MSDE) and Microsoft Windows Server 2003 family use, there is known security weaknesses. In order to reduce the attack of the computer, Microsoft SQL Server 2000, MSDE or both TCP / IP and UDP network ports are disabled. To enable these ports, you must
http://www.microsoft.com/sql/downloads/default.asp or
Http://www.microsoft.com/chna/sql/downloads/default.asp Install a patch, or the latest service pack for Microsoft SQL Server 2000 or MSDE. For more information, please refer to
Help and support from http://go.microsoft.com/fwlink/events.asp, you can see that Windows Server 2003's TCP / IP and UDP ports of SQL Server have caused the database that cannot be connected. "
According to the above information, download the latest SQLServer 2000 SP3A upgrade package from Microsoft. If only the database server is installed, download the database component upgrade package (I test).
After downloading, unpack it to the specified folder. Here, I made a very low-level mistake, because after unpacking, the pop-up prompt "has successfully passed the package", I thought it was successful, who knew it or not access, I want to have other patches No download, I also downloaded a lot of patches, but I still can't do it. I wanted to see what I have in SP3. I didn't expect to have "setup.bat" inside. I really can't laugh, I have to execute it. After upgrading, what is wrong, and the JSP developed under Windows 2000 can be used again.
Here, it is recommended that the SQL Server 2000 under what platform is upgraded to the latest version, and security can be improved, avoiding incompatible problems.
The biggest feeling for this question is: Microsoft's things have been upgraded every day, pay close attention to the dynamics of Microsoft home page, and his system is upgraded once, and the other has to upgrade, or if it is "unsafe" or "incompatible".
The inspiration to me is: This can really improve the amount of website access, I think I also develop a software, everyone is used, then upgrade every day, or other promotion? My homepage is "http://javalet.com" construction site for two and a half years, due to time relationship, have not been done, wait for the future, slowly improve it.
