?
Solved

how to stop  the exclusively access to the SQL database

Posted on 2006-05-16
12
Medium Priority
?
243 Views
Last Modified: 2012-05-05
Hi,

I'm using a third party software that is storing the data in an SQL 2000 Database on my Server. Using the "designer tool" of that software I was working on the database design. Then this designer software crashed and I can not access the databases with that tool anymore, as I receive the message "you cannot open this database exclusively as it is already in use" when I try to open them.

I restarted and bootet everything, but could not find the way to "unlock" the sql databse.

Any idea?

Joe
0
Comment
Question by:corma
  • 3
  • 3
  • 2
  • +2
10 Comments
 
LVL 27

Expert Comment

by:ptjcb
ID: 16694097
Do you have access to Enterprise Manager?
0
 

Author Comment

by:corma
ID: 16694116
Yes, I have access to the Enterprise Manager.
0
 
LVL 27

Expert Comment

by:ptjcb
ID: 16694137
Ok..good. Do you have sysadmin rights on the database? What are your rights on that database?

0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:corma
ID: 16694172
I have administrative rights to all the servers, incl. the sql-server. For the database there is one user/role "public" and one "i2BaseSSE" which seems to come from the thirs Party Application. Type of this user/role is "application".

I'm sure I can get any right I need.

Sorry for the strange wording, using a german win2003 server :-)

0
 
LVL 13

Expert Comment

by:Atlanta_Mike
ID: 16694610
This might be fun...

If a connection is already made, you'll need to do an sp_who2 and kill the connection. Then right mouse click on the database go to properties, options and uncheck restrict access.
 
0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 16695167
is the message comming from the thirdparty tool or a sql server message...

please post it exactly...

I'd guess it was from the third party tool and that the tool employs a lock technique
to internally "book out" a "design" to a specific user....

the problem is likely to be resolved via the tool and access to the tools administrator menu's...
have you consulted the third party manuals...
or their support desk for the required corrective actions...

it would help if you could tell us the name of the tool involved..

 
0
 
LVL 27

Expert Comment

by:ptjcb
ID: 16699319
That's a good point Lowfatspread - you can check if the message is from SQL Server by opening QA and performing a simple query on the database. If you have results then it is the 3rd party tool.

0
 

Author Comment

by:corma
ID: 16699548
Hi all,

today I reached the support of my third party provider...and it tokk them some hours..but here's the solution:

Using the Enterprise Manager and looking at the tables there's one called "_configuration" which contains the field "SQLServer: Exclusive" which contained data with my username and the workstation name...after deleting that data entry I could access the data again.

Thanks for your ideas and energy.

Joern
0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 16699890
i'm surprised that the tool requires you to clear this via Enterprise manager this functionality should be present within the tool

even if only to an Administration user (for the tool)...

as i'd have thought that apart from the "lock" table other "administrative task would be required to cleanly "roll-back" any design
changes that you had initiated"  

if it doesn't support these features then i'd guess the tool is very immature, and you should be pressing for the tool to be
modified to address this area , at the next user group forumn that is available.


I'd also spend some time ensuring that i was confident about the "state" of the design that the tool was now presenting
before proceeding further...  It shouldn't take a support desk very long to identify this type of problem...




good luck


hth
0
 

Accepted Solution

by:
GranMod earned 0 total points
ID: 16918598
PAQed with points refunded (500)

GranMod
Community Support Moderator
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question