What it means
The server has been put into restricted mode, so it refuses new database opens from ordinary users and servers. Administrators can still get in.
Common causes
Server_Restricted=1set for the current session (cleared by a restart)Server_Restricted=2set, which stays in force after restarts- A disaster recovery or maintenance server deliberately left restricted
- The setting pushed to the server from a Configuration Settings document
Quick fixes
- On the server console, check the current value with
show config Server_Restricted - If the restriction is no longer wanted, run
set config Server_Restricted=0 - Check the NOTES.INI Settings tab of any Configuration Settings document that applies to the server, or the value will come back
- Remember that replication and replica creation from other servers are also blocked while it is set