Connery and Rowling are among many Scottish and Scotland-based stars making public interventions on independence ahead of Thursday's referendum—though experts say their influence on the outcome may be limited.
Pro-independence celebs include actor Gerard Butler, members of the band Franz Ferdinand and "Trainspotting" author Irvine Welsh, who has half-joked that "the Union is nature's way of stopping the Scots ruling the world."
Alan Cumming, who plays spin doctor Eli Gold on "The Good Wife," flew in from his Broadway run in "Cabaret" this week to hit the pro-independence campaign trail.
"It's an historic moment for us all. We now have a chance in this country to have our own destiny in our own hands," Cumming said. Other stars have decided that Scotland and the rest of the U.K. are—in the words of the anti-independence campaign—"Better Together."
Read MoreScottish vote: UK business leaders scaremongering?
Singer Susan Boyle, who still lives in the Scottish village where she grew up, has said she plans to vote No, telling the Scottish Sun newspaper that "we have still been able to retain our proud identity whilst being a part of Britain."
Former Manchester United manager Alex Ferguson, Britain's most successful soccer coach, said Scots like him who live in in England "don't live in a foreign country; we are just in another part of the family of the U.K."
Sociologist Ellis Cashmore, author of the book "Celebrity Culture," said the opinions of celebrities would have a muted impact on the outcome of the vote, which polls suggest is too close to call.
"Celebrities are most effective in influencing people when the central issue is not prominent in voters' minds," he said, citing campaigns by U2's Bono and Coldplay's Chris Martin to raise awareness of famine and conflict in the developing world.
Read MoreAnew Scotland, the 'Singapore' ofEurope?
Cashmore said people in Scotland, and Britain at large, are already preoccupied with the independence issue, so celebrity interventions have little impact, and could even backfire.
"It's become like a pie-eating contest: the first few mouthfuls were tasty, but now we're getting sick of the number of celebs who are speaking on a subject we suspect they don't understand."