jsp连接sql2000时：Error establishing socket.

MS SQL2000 （Error establishing socket）错误的解决办法-SQL请选用混和安装模式

<script language="JavaScript" type="text/JavaScript"></script>

<script type="text/javascript"> </script><script type="text/javascript"> </script>

• -----------------------------------------------------------------------------------------
  
  *  Error:  get  DB  connection  error.  Ex.  msg:  java.sql.SQLException:  [Microsoft][SQLServer  2000  Driver  for  JDBC]Error  establishing  socket.  
  java.sql.SQLException:  [Microsoft][SQLServer  2000  Driver  for  JDBC]Error  establishing  socket.  
             at  com.microsoft.jdbc.base.BaseExceptions.createException(Unknown  Source)  
             at  com.microsoft.jdbc.base.BaseExceptions.getException(Unknown  Source)  
             at  com.microsoft.jdbc.base.BaseExceptions.getException(Unknown  Source)  
  ---------------------------------------------------------------  
  无法建立数据库连接,    
  确定网络没有问题  
  SQL有开着,  
  把SQL打到SP3的补丁  
  驱动也要对应SP3的.  
   
  ---------------------------------------------------------------  
  1、下载Microsoft  SQL  Server  2000  Service  Pack  3a并安装，SQL请选用混和安装模式！！！  
  http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=zh-cn  
   
  2、下载SQL  Server  2000  Driver  for  JDBC  Service  Pack  3  
  http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en  
   
  3、运行时关闭防火墙

• 4.telnet 127.0.0.1 1433 检查mssql端口是否正常