Does SphereShield need its own SQL server or instance?

No, it can be collocated on an existing instance.