I recently tried to restore to my local development SQL Server a backup from a network instance. To my surprised I received the following error message:
Msg 12824, Level 16, State 1, Line 3 The sp_configure value 'contained database authentication' must be set to 1 in order to restore a contained database. You may need to use RECONFIGURE to set the value_in_use. Msg 3013, Level 16, State 1, Line 3 RESTORE DATABASE is terminating abnormally.
What steps must I follow to successfully restore the database?