11 个解决方案
#1
达到最大连接数了?
#2
查看现在的最大连接数
#3
没有,才刚开始测试连接,
#4
会不会因为防火墙问题
#5
在 sql server configuration manager 中启动 sql server服务
#6
检查服务器1433端口是否打开,如果都正常,要不就是服务器硬防之类的拦截了。。如果排除防火墙之类的拦截问题,再看下你是不是做了IP安全策略。。策略禁止了连接!如果都正常。。。。。。绝招了,你在服务器连接下本地的MSSQL,如果能连,就重启服务器吧。。。还是不能连的话,人品问题!爱莫能助
#7
启动了
#8
哦,谢谢楼上
#9
#10
应该不是网络问题,我不用NHibernate ,可以连接,请教大家为啥呢
#11
我的hibernate.cfg.xml配置文件,有错么
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" >
<session-factory name="NHibernate.Test">
<!-- properties -->
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
<property name="connection.connection_string">server=10.1.7.20;Initial Catalog=nhibernate;uid=team;pwd=team;;Pooling=False</property>
<property name="adonet.batch_size">10</property>
<property name="command_timeout">10</property>
<property name="show_sql">true</property>
<property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property>
<property name="use_outer_join">true</property>
<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
<property name='proxyfactory.factory_class'>NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle</property>
<!-- mapping files -->
<mapping assembly="testnh" />
</session-factory>
</hibernate-configuration>
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" >
<session-factory name="NHibernate.Test">
<!-- properties -->
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
<property name="connection.connection_string">server=10.1.7.20;Initial Catalog=nhibernate;uid=team;pwd=team;;Pooling=False</property>
<property name="adonet.batch_size">10</property>
<property name="command_timeout">10</property>
<property name="show_sql">true</property>
<property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property>
<property name="use_outer_join">true</property>
<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
<property name='proxyfactory.factory_class'>NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle</property>
<!-- mapping files -->
<mapping assembly="testnh" />
</session-factory>
</hibernate-configuration>
#1
达到最大连接数了?
#2
查看现在的最大连接数
#3
没有,才刚开始测试连接,
#4
会不会因为防火墙问题
#5
在 sql server configuration manager 中启动 sql server服务
#6
检查服务器1433端口是否打开,如果都正常,要不就是服务器硬防之类的拦截了。。如果排除防火墙之类的拦截问题,再看下你是不是做了IP安全策略。。策略禁止了连接!如果都正常。。。。。。绝招了,你在服务器连接下本地的MSSQL,如果能连,就重启服务器吧。。。还是不能连的话,人品问题!爱莫能助
#7
启动了
#8
哦,谢谢楼上
#9
#10
应该不是网络问题,我不用NHibernate ,可以连接,请教大家为啥呢
#11
我的hibernate.cfg.xml配置文件,有错么
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" >
<session-factory name="NHibernate.Test">
<!-- properties -->
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
<property name="connection.connection_string">server=10.1.7.20;Initial Catalog=nhibernate;uid=team;pwd=team;;Pooling=False</property>
<property name="adonet.batch_size">10</property>
<property name="command_timeout">10</property>
<property name="show_sql">true</property>
<property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property>
<property name="use_outer_join">true</property>
<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
<property name='proxyfactory.factory_class'>NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle</property>
<!-- mapping files -->
<mapping assembly="testnh" />
</session-factory>
</hibernate-configuration>
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" >
<session-factory name="NHibernate.Test">
<!-- properties -->
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
<property name="connection.connection_string">server=10.1.7.20;Initial Catalog=nhibernate;uid=team;pwd=team;;Pooling=False</property>
<property name="adonet.batch_size">10</property>
<property name="command_timeout">10</property>
<property name="show_sql">true</property>
<property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property>
<property name="use_outer_join">true</property>
<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
<property name='proxyfactory.factory_class'>NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle</property>
<!-- mapping files -->
<mapping assembly="testnh" />
</session-factory>
</hibernate-configuration>