I've connected the ethernet cable into the ethernet port but the light isn't on. Would it light up if the ethernet cable is not connected on the router (ie the cord is only connected on the PC side)?
If you've over/underclocked the PC and messed with the PCI-E frequency it can cause the LAN adapter not to work. Also the lights might only work when the drivers are loaded.