The following video shows where you can find Ingward in Dark Souls. Ingward is located in New Londo Ruins. He will provide you with the key to the seal if you have the lordvessel. You can also purchase the spell Resist Curse and also the item Transient Curse to Ingward. Transient Curse allows you to kill ghosts for a period of time.