• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1161
  • Last Modified:

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

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
novice12
Asked:
novice12
  • 8
  • 3
1 Solution
 
novice12Author Commented:
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
 
Aneesh RetnakaranDatabase AdministratorCommented:
That's how we change to multi user ,
0
 
novice12Author Commented:
That did not work - It keeps coming back with:
The database is already open....can not open it
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
novice12Author Commented:
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
 
novice12Author Commented:
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
 
Aneesh RetnakaranDatabase AdministratorCommented:
Was there any maintenace plans running /
0
 
novice12Author Commented:
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
 
novice12Author Commented:
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
 
Aneesh RetnakaranDatabase AdministratorCommented:
is it still executing ?
0
 
novice12Author Commented:
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
 
novice12Author Commented:
Yes it's running fine now. I am going to monitor it, to see if the problem comes back tomorrow.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 8
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now