Error 924 in SQL database

• isabella.garcia7790

  SSC Enthusiast

  Points: 196

  More actions

  October 24, 2018 at 9:18 pm

  #377973

  Hello Experts,

  I am using SQL Server Express edition. I gor the following error message:
  Msg 924, Level 14, State 1, Line 1 Database ‘database_name’ is already open and can only have one user at a time.

  Please help me to fix this error.

  Thanks,
  Isabella

• Eirikur Eiriksson

  SSC Guru

  Points: 182912

  More actions

  October 25, 2018 at 1:04 am

  #2011067

  isabella.garcia7790 - Wednesday, October 24, 2018 9:18 PM

  Hello Experts,

  I am using SQL Server Express edition. I gor the following error message:
  Msg 924, Level 14, State 1, Line 1 Database ‘database_name’ is already open and can only have one user at a time.

  Please help me to fix this error.

  Thanks,
  Isabella

  This is a single_user connection problem, check this article for a solution.
  😎

  Do NOT try any other "fixes" as this is simply a connection problem.

• Johnson Welch

  SSCoach

  Points: 18773

  More actions

  October 29, 2018 at 12:50 am

  #2011478

  Microsoft SQL error 924 occurs when an attempt is been made to access the database by another user which is set as a single-user mode. Identify the currently running session using exec sp_who2 command or by using SSMS Activity Monitor. Kill whatever the process has a hold on the Database. 
  This may help you out:
  http://mahedee.net/fix-sql-error-924/

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  October 29, 2018 at 7:41 am

  #2011524

  Eirikur Eiriksson - Thursday, October 25, 2018 1:04 AM

  isabella.garcia7790 - Wednesday, October 24, 2018 9:18 PM

  Hello Experts,

  I am using SQL Server Express edition. I gor the following error message:
  Msg 924, Level 14, State 1, Line 1 Database ‘database_name’ is already open and can only have one user at a time.

  Please help me to fix this error.

  Thanks,
  Isabella

  This is a single_user connection problem, check this article for a solution.
  😎

  Do NOT try any other "fixes" as this is simply a connection problem.

  Exactly this - other fixes are unnecessary.
  Be careful of any post that mentions sp_dboption as well (with incorrect examples) since it's not even available on supported versions of SQL Server anymore, That's nothing other than a huge red flag.

  Sue

• Eirikur Eiriksson

  SSC Guru

  Points: 182912

  More actions

  October 29, 2018 at 8:25 am

  #2011528

  Johnson Welch - Monday, October 29, 2018 12:50 AM

  Microsoft SQL error 924 occurs when an attempt is been made to access the database by another user which is set as a single-user mode. Identify the currently running session using exec sp_who2 command or by using SSMS Activity Monitor. Kill whatever the process has a hold on the Database. 
  This may help you out:
  http://mahedee.net/fix-sql-error-924/

  This is a very misleading and bad advice, do you understand what the problem is?
  😎