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 restart cause this trouble. So to fix this you just need to use below script to change recovery state to RECOVERY. RESTORE DATABASE YourDatabaseName WITH RECOVERY