This sound effect can be found on Sound Effects 2, which was made by William B Tanner Company.
https://soundeffects.fandom.com/wiki/File:William_B_Tanner_Company,_Door_Knock_And_Open.ogg