请问hibernate连接SQL SERVER2000 显示无法连接是怎么回事?

Question

我使用My eclipse数据库工具来建立对SQL Server2000的连接,配置如下:
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>    <session-factory>
        <property name="connection.username">sa</property>
        <property name="connection.url">jdbc:microsoft:sqlserver://localhost:1433/university</property>
        <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
        <property name="myeclipse.connection.profile">SQL Server</property>
        <property name="connection.password">sa</property>
        <property name="connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>
    
    </session-factory></hibernate-configuration>

Answer 1

<property name="connection.username">sa </property> 
<property name="connection.password">sa </property>
注意到你这两行的sa后面都有一个空格，估计这个空格是多余的。

Answer 2

把<property name="connection.url">jdbc:microsoft:sqlserver://localhost:1433/university </property>
改成
<property name="connection.url">
jdbc:microsoft:sqlserver://192.168.0.202:1433;DatabaseName=university
</property>
试试!

Answer 3

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>
<!-- proxool连接池使用 应把配置文件放到class目录下-->
<session-factory>
<!--

<property name="proxool.pool_alias">SBPool</property>
<property name="proxool.xml">proxoolconf.xml</property>
<property name="connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
-->
<property name="connection.username">sa</property>
<property name="connection.url">
jdbc:microsoft:sqlserver://127.0.0.1:1433
</property>
<property name="dialect">
org.hibernate.dialect.SQLServerDialect
</property>
<property name="myeclipse.connection.profile">test</property>
<property name="connection.password">sa</property>
<property name="connection.driver_class">
com.microsoft.jdbc.sqlserver.SQLServerDriver
</property>
<property name="show_sql">true</property>
<mapping resource="com/hibernate/hbm/UserTable.hbm.xml" />
<mapping resource="com/hibernate/hbm/Course.hbm.xml" />
<mapping resource="com/hibernate/hbm/Goods.hbm.xml" />
<mapping resource="com/hibernate/hbm/Member.hbm.xml" />
<mapping resource="com/hibernate/hbm/Province.hbm.xml" />
<mapping resource="com/hibernate/hbm/Country.hbm.xml" />
<mapping resource="com/hibernate/hbm/Companyinfo.hbm.xml" />
<mapping resource="com/hibernate/hbm/Bbs.hbm.xml" />
<mapping resource="com/hibernate/hbm/Employ.hbm.xml" />
<mapping resource="com/hibernate/hbm/Replybbs.hbm.xml" /> </session-factory></hibernate-configuration>