If every one of the connections to your DVD drive are safe, then it’s feasible that the board regarding the DVD drive has a quick inside it or even a blown surface-mount fuse. Take away the DVD drive and change it with a brand new anyone to see if that actually works. You can either replace the entire drive, or try to find a replacement board if it does.
Then it may be a bad motherboard if the cables and the drive are not the problem that cause the DVD drive not to turn on. It is hard to evaluate this without acquiring a brand new motherboard or testing your DVD drive on a known working console. Read more