I tried with both internal and external psu
Both light the card up and fans spin.
I tried adapter for internal. 6 pin to 8.
Nothing.....
Typically, "lighting up" the card refers to it producing output on its ports (which indicates it's working) as opposed to any LED on the card. It is highly likely that card turns on the LED and fans well before it's fully powered.
That Sapphire card you mention is a reasonably power-hungry card, rated out of the box as a 300W card, so the 6-pin PCIe power connectors (75W each) are unlikely to provide enough. If you used an external PSU to drive both 8-pin PCIe power connectors (150W each!), and it still doesn't power any monitor, it sounds like the card may be bad.
The Mac Pro power specs are considered to be about 75W max to each PCIe slot, plus 75W max per each 6-pin PCIe power adapter for a maximum single internal PCIe card draw of 225W (75W + 75W +75W). Some folks bring down one of the four-pin Molex peripheral power plugs from the ODD bays into the PCI area since they are typically thought of as max 187W so they can drive an 8-pin PCIe max 150W, but then you're playing on the edges of balancing all the power across the main Mac Pro PSU (bigger CPU? lots of RAM? Bluray?), especially if you already have a lot of drives taking power. It's also not clear how much power the Mac Pro ODD Molex plugs can really provide reliably as they were intended for 15W-25W DVD drives!
That's why most people with a Mac Pro look for cards that can properly run with two 6-pin PCIe power connections or less. The MSI has one 6-pin and one 8-pin, but it ships with a 6-pin-to-8-pin connector
in the box, which is what originally gave people hope that it'd be <=225W draw. It seems to work, which is what got me to try this card. Even then, the card is spec'd at 250W by many reviews so there is some risk that pushing the GPU to the edge (which doesn't seem to happen in even intense gaming, but perhaps possible with big video rendering tasks) might push it beyond the max the Mac Pro can provide. It's also unclear what version of the card a review uses that states the 250W, as there seems to have been at least two different ones so my second version may be a bit more power efficient and that's all the difference? All I know is that the MSI works for me, and seems to work for others, that's why I posted the exact model I have for guidance.
All this stuff is enough for some people to just buy a pre-flashed one from a reputable source, like folks on this forum who have been so helpful over time in figuring this out.
UPDATE: Surfing around gives inconsistent power specs for this MSI card, some say 250W, others say 190W, furthering the notion that perhaps things changed across versions. The fact that it ships from MSI with cables meant to be plugged into two 6-pin PCIe power ports was still key for me.