22 January,2011 by Jack Vamvas
After a SQL Server Restore on a database – I saw the database set at RESTRICTED USER mode.
The result of the database set with RESTRICTED USER is it prevents new connections being made to the database by users who do not have the appropriate database roles assigned.
Users were not able to access the database.
I Solved the problem by issuing these commands:
ALTER DATABASE mydatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO ALTER DATABASE mydatabase SET MULTI_USER GO