Is the 40 MB 2.5 SCSI HD a Conner? If so, then those weren't very reliable and had a tendency to die, so I'm pretty sure the HD's toast.

The reason why it has no SCSI power connector is because power is provided in the 2.5 SCSI connector, similar to a 2.5 IDE hard drive.

Here is a suitable adapter.