-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: Connecting to SQL Server 2012 Express
PostPosted: Tue Oct 01, 2013 8:22 am 
Newbie

Joined: Tue Oct 01, 2013 8:13 am
Posts: 2
I created a web app that connects to SQL Server 2008 Express and it worked perfectly. We then migrated the database to a new pc and upgraded the SQL server to 2012 Express. I changed all the credentials in hibernate.cfg.xml correctly to point at the database in its new location. Through some network traffic and connection monitoring I can see that there is indeed a connection being made to the pc from the application on port 1433 and it is being handled by the SQL Server. Thats as far as it gets. From viewing the SQL that is generated by Hibernate it looks like it gets to the point of offering credentials (username and password) and then just stopping. It doesn't seem to be able to talk to SQL Server 2012 correctly and give the credentials. Any thoughts?


Top
 Profile  
 
 Post subject: Re: Connecting to SQL Server 2012 Express
PostPosted: Sat Feb 08, 2014 12:21 pm 
Newbie

Joined: Sat Feb 08, 2014 12:02 pm
Posts: 2
Hey,

Were you able to get the issues resolved? I am in a similar situation and not get to get my way out. s

Sudeep


Top
 Profile  
 
 Post subject: Re: Connecting to SQL Server 2012 Express
PostPosted: Mon Feb 10, 2014 10:11 am 
Newbie

Joined: Tue Oct 01, 2013 8:13 am
Posts: 2
Yes I did eventually get it working. I can't quite remember the details of what I did to fix it. My web app was actually a Flash program. I remember having to make sure my Hibernate jar was the most recent so that it could talk to Server 2012. I also had to re-create the ODBC connection to the database to give the correct permissions to the application. I think those were the 2 things that were the fix. Sorry I can't be of more help it was 4 months ago and I did not document it well.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.