Fix The database is not accessible. Database in restoring state. SQL server

This problem comes when database is restored with “RESTORE WITH NORECOVERY” state or some times even sql services …

source