Tried to logon again, but couldn’t! The same message. I tried to start the SQL Server Service, and it started successfully. Ok, let’s check Config Mngr – the service is stopped! Strange, it shouldn’t be. Great! One more task from the checklist is done, while of course thinking about completely different thinks and watching my baby’s first steps! BUT when I started the SSMS and tried to login the “nice” messages came in.įirst, I couldn’t connect to my SQL Server (network protocol message error message + something like it is in the process of updating and only the administrator could connect (!) That’s me! I am the administrator!.). After several minutes I saw the lovely green icon and the message of successful installation. OK, so I closed it and started the patch again.

I even forgot to close the SSMS and the installation process kindly reminded me that it didn’t have control over SSMS. So I run the SP2 installation, went trough the Wizard and started the process.

While I know perfectly the meaning of this sentence I was not as careful as needed applying the SQL Server 2008 R2 SP2, because it was on my laptop, and I did couple of other things meanwhile including listening to my baby girl first songs 🙂 Refresh the System databases to see that Master is in Multiuser Mode.When applying SP to SQL Server you need to be careful, I mean really, with planning and attention to every step and especially to errors if any appear. Give required file level permission to both these files.ĩ. Rename the original master database files to master.oldmdf and mastlog.oldldf and rename the user database to master.mdf and mastlog.ldf.ħ.

Execute the below command to set the database in multi-user mode.Ĥ. After the restore, the user database will also show as (Single User).ģ. Backup master database that you see in single-user mode. But you can restore the master from the previous backup as a user database and replace the. Satish is right, you cannot set master database to multi_user mode. The master database may be go into a single user mode after restore.

Master database in sql server