?
Solved

Urgent!.  Error 22285:SQL-DMO Database 'MyDatabase'; already open and can only be open by one user

Posted on 2006-11-28
11
Medium Priority
?
1,143 Views
Last Modified: 2008-01-09
I have SQL 7 database that all of a sudden has a mark next to the name (if you are looking in EM) as 'single user'.
When I try to open any of the table, I am getting the error:
Error 22285:SQL-DMO Database 'MyDatabase'; already open and can only be open by one user

How would I resolve this?
0
Comment
Question by:novice12
  • 8
  • 3
11 Comments
 

Author Comment

by:novice12
ID: 18028029
I found this on the web, that I am going to try:

ALTER DATABASE Mydatabase SET MULTI_USER WITH ROLLBACK IMMEDIATE

What do you think?
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 18028097
That's how we change to multi user ,
0
 

Author Comment

by:novice12
ID: 18028409
That did not work - It keeps coming back with:
The database is already open....can not open it
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:novice12
ID: 18028468
I am sorry I forgot to mention that this is a SQL 7 database. I did not use the query above, I used a SQL 7
I think it was : set db_option 'single user' , 'false'
but that won't work, because the databse is in single user mode, and it will only allow one conetion. Currently I am disconnecting the server from the network, and rebooting....
0
 

Author Comment

by:novice12
ID: 18028726
Ok, after disconnecting the server form the network. I still wasn't able to do:
Exec sp_dboption VisitorReg, 'single user', 'false'
When I wen to database property in EM, I was able to un-check single user. And it worked!

I just don't know how did the database ended up being in single user to begin with. Can the database automatically go into 'single user'. It must be a SQL batch doing it, maybe?

Thanks

0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 2000 total points
ID: 18028850
Was there any maintenace plans running /
0
 

Author Comment

by:novice12
ID: 18029042
I am showing that one job has failed, the message is as follows:
Integrity Check Job for VisitorReg has failed.

The maintanance plan that executes this job, is set to write to the windows event-viewer only. The event viewer size however is too small. So at this point I know that this job has failed, I just don't know why?
0
 

Author Comment

by:novice12
ID: 18029144
I looked under SQL server Logs and I saw logs of the above maintanance plan executing. I did not see any errors logged however.
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 18029163
is it still executing ?
0
 

Author Comment

by:novice12
ID: 18029183
I have SQL 7 , sp 2.
There is an article in MSDN about this problem.
http://support.microsoft.com/default.aspx?scid=kb;en-us;276234


0
 

Author Comment

by:novice12
ID: 18029491
Yes it's running fine now. I am going to monitor it, to see if the problem comes back tomorrow.
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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
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.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

850 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