SQL Server 2005->Problems while changing restrict access property from Restricted_User to MULTI_User

• jeet_personal

  Right there with Babe

  Points: 765

  More actions

  May 5, 2009 at 1:26 pm

  #384507

  Hi

  I am not able to change the restrict access property from Restricted_User to MULTI_User.

  I have tried both from Management Studio as well as writing Query

  ALTER DATABASE rtcdyn SET MULTI_USER

  Everytime I am getting error :"Lock request time out period exceeded."

  "ALTER DATABASE statement failed."

  Please note I have the SQL Admin rights.

  Thanks,

  Jeet

• jeet_personal

  Right there with Babe

  Points: 765

  More actions

  May 5, 2009 at 3:41 pm

  #989241

  I got the Answer ...

  We need to kill the existing connection..

  In order to do that the best way is to follow these steps:

  1.Right Click on the database.

  2.Click to detach the database

  3.Click on the active connections

  4.Kill the connections.

  Then run the ALTER database Statement to change the Restric Access property of the Database.