Could not open connection hibernate

Question

I'm using Hibernate to connect to MSSQL 2012, I have cfg.xml like this

 <property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="hibernate.connection.url">jdbc:sqlserver://USER-PC:1433;databaseName=AvtoParki;integratedSecurity=false               databaseName=AvtoParki;integratedSecurity=false</property>
<property name="hibernate.connection.username">user</property>
 <property name="hibernate.connection.password"></property>-->
<property name="hibernate.connection.pool_size">10</property>
<property name="show_sql">true</property>
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="hibernate.hbm2ddl.auto">create-drop</property>
<!-- Mapping files -->
<mapping class="Employee" />

my PC userName is "user", and I'm connecting to SQL by windows authentication I don't have any password on it , so When I run application session.beginTransaction() throws error: "Login failed for user 'user'. Couldn't open connection". Can anyone solve this problem?

bjnr · Accepted Answer · 2013-12-15 12:21:24Z

1

Integrated security should be set to True as you want to connect using Windows Authentication:

<property name="hibernate.connection.url">
jdbc:sqlserver://USER-PC:1433;databaseName=AvtoParki;integratedSecurity=true;
</property>

answered Dec 15, 2013 at 12:21

bjnr

3,4371 gold badge24 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Could not open connection hibernate

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related