For this kind of database connection problem, there are always two distinct issues:The SQL server itself is not running or TCP/IP is disabled. That ca......
\MSSQLServer\SuperSocketNetLib\TCP\TcpPort
. On the Edit menu, click String. Enter either of the following values: a. Type the port number you want. -or- b. Enter a value of 0 to have SQL Server dynamically detect and assign a port the next time SQL Server starts.
Click OK.
Quit Registry Editor.
SQL Server 2000 Service Pack 4 (SP4):
You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with the Microsoft Windows Server 2003 family. To reduce your computer’s vulnerability to certain virus attacks, the TCP/IP and UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been disabled. To enable these ports, you must install SQL Server 2000 Service Pack 3a, or the most recent service pack for Microsoft SQL Server 2000 or MSDE from http://www.microsoft.com/sql/downloads/2000/sp4.mspx.
2/2 首页 上一页 1 2 |