Link to home
Start Free TrialLog in
Avatar of Allen2012
Allen2012

asked on

I am trying to ALTER database from SINGLE user to MULTI-USER access level.

I am trying to ALTER database from SINGLE user to MULTI-USER access level.
using this command, and get the following error.  Please help.

ALTER DATABASE db SET MULTI_USER



ERROR Message:
-----------------------

bodyMsg 5064, Level 16, State 1, Line 1

Changes to the state or options of database 'niku' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.

Msg 5069, Level 16, State 1, Line 1

ALTER DATABASE statement failed.

Avatar of Darius Ghassem
Darius Ghassem
Flag of United States of America image

Restart the SQL Services this will allow you to run the command
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Allen2012
Allen2012

ASKER

thanks