Montgomery Scott's middle name is Edward, revealed in Star Trek: The Next Generation episode "Relics" (S6E4), when the Enterprise-D crew recovers him from a transporter buffer.
Full name: Montgomery Edward Scott.