Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
WrecknRoll
Starting Member
9 Posts |
 Posted - 2011-10-05 : 19:12:59
|
| I am trying to run a JBoss application and it is failing when trying to access my SQL database. The full error is:Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: java.sql.SQLException: Cannot open database "cabinet" requested by the login. The login failed.I have adjusted my SQL Network Protocol settings making sure all are Enabled except VIA.Any help on why I'm getting this would be much appreciated! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
WrecknRoll
Starting Member
9 Posts |
Posted - 2011-10-06 : 13:05:08
|
Thanks for replying. I think it will work with my user's default database being master but that is not the way this application is supposed to be configured. But in checking that after reading your message I noticed my user had lost all its User Mapping settings.No idea why this happened but after resetting these my application is working, I'm no longer getting this error.Thanks again...quote:
Originally posted by tkizer
Change the default database to master and then try again.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
|
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Error: Acquisition Attempt Failed