Solved

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

Posted on 2006-11-28
11
1,129 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

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 500 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

724 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