One of the databases is shown as a single user. How can I change this database to a multi-user?
Please complete the following steps to turn the database into multi-user mode from SQL management studio:
Take a backup
Create new database and restore the backup to it.
Select Properties
Options
[Scroll down] State
RestrictAccess
select Multi_user
click OK
Delete the old database.
If the above steps cannot be actioned or produce errors, please raise a new case online and reference the title of this article.