Sevilla beat Benfica on penalties to win the Europa League in Turin, their third triumph in the competition in nine seasons.
Benfica, losers in their seven previous European finals, were seeking a first continental trophy since 1962.
And the Portuguese side might have ended that sequence had Lima's late effort not been hooked off the line.
It fell to Kevin Gameiro to score the winning spot-kick after Sevilla keeper Beto denied Oscar Cardozo and Rodrigo.
Carlos Bacca, Stephane Mbia, who is on loan from Queens Park Rangers, and Jorge Moreno were also on target for the Spanish club.
Brazilian Lima and Luisao did find the net for Benfica but Lisbon-born Beto denied the side from his home city with crucial saves to keep out Cardozo and Rodrigo.
Sevilla also won the competition in 2007, beating Espanyol on a penalty shootout
Sevilla overcame fellow Spanish side Espanyol on penalties to win the 2007 final, 12 months after beating Middlesbrough for their first success in the competition, known then as the Uefa Cup.
But while Los Rojiblancos's 9,000 travelling fans celebrated another triumph in Europe's second-tier club competition, Benfica's long wait for success on the continent continues.
Despite recently sealing a 33rd domestic title, their attempt to rid themselves of the increasingly troublesome "Guttmann curse" goes on.
Benfica's Hungarian coach of the early 1960s Bela Guttmann led the club to back-to-back European Cups but left shortly after the second of those triumphs when he was refused a pay rise.
Before going he declared that Benfica would never win another European competition without him at the helm. Fifty-two years on, they have still to prove him wrong.
Jorge Jesus's side had beaten Tottenham and Juventus on their way to the final, and were chasing a unique domestic and European quadruple.
A largely uneventful opening half came to life shortly before the interval, Beto saving from Benfica's Spanish forward Rodrigo at his near post moments after denying Maxi Pereira.
Then the Lisbon club were denied a stoppage-time penalty, German referee Felix Brych waving away strong Portuguese appeals after a foul on Nicolas Gaitan.
There was more action in the first five minutes of the second half than the previous 45 as Benfica carried on from where they left off.
Nicolas Pareja hooked Lima's shot off the line before Rodrigo's goal-bound attempt was charged down.
Spanish strife
Benfica are without a win in their last 14 European games against Spanish opponents (D6 L8)
Sevilla responded with a sweeping move of their own, Moreno picking out Jose Antonio Reyes, but the former Arsenal striker's first-time shot produced a fine save from Jan Oblak.
Six minutes from the end of normal time, Benfica's Lima thought he had won it with a curling shot which Beto somehow managed to claw away.
Chances were few and far between in extra time as the players tired and nerves increased, though Bacca went close when he raced through on goal, only to fire his effort wide.
But Sevilla's frustration did not last long, as they sent their fans into raptures with four well-taken penalties to extend Benfica's European misery.
Sevilla manager Unai Emery:
"At times the game was totally even, but by the end they were doing most of the pushing.
"You could tell our players were suffering from fatigue and physical discomfort but this team has learned how to suffer.
"We have learned how to stay strong and so we were ready for that."
Benfica coach Jorge Jesus:
"We were better but in football, the best team doesn't always win. We had the more chances over 120 minutes but we didn't take them."
Latest Stories
-
GPL 2024/25: Asante Kotoko bounce back with win over Aduana FC
21 mins -
GPL 2024/25: Gold Stars beat Vision FC to retain top spot
59 mins -
Ebo Whyte returns with ‘The 4Play’
1 hour -
2024/25 Ghana League: Heart of Lions sink Legon Cities to go third
2 hours -
Bright Simons: DBG, Ghana’s top development bank, goes for the jugular
3 hours -
Governance and Entrepreneurship consultant demands global support for Africa’s young farmers
3 hours -
Ghanaians reminded to prioritise regular health check-ups
3 hours -
Salah brace sends Liverpool 8 points clear
3 hours -
Leicester City sack manager Steve Cooper
3 hours -
Akwasi Sarpong wins AIBs 2024 Award for BBC OS coverage of Israeli hostage release
3 hours -
Gospel musician Adeline Baidoo shares inspiring story of triumph over adversity
3 hours -
Kwesi Yankah: Escape from Ghana
4 hours -
Musician DeThompson DDT drops new single Happiness
4 hours -
Ukraine’s Grain Initiative raises over $200m, provides lifeline amid global food crisis
5 hours -
Dancehall queen Spice donates to students of 3 basic schools in Accra through MYO Global Foundation
5 hours