What was the setting of Sean Connery film rock?

There is no Sean Connery film called "Rock". It's possible you are thinking of a different film, perhaps:

* The Rock (1996) - This action thriller film stars Nicolas Cage and Sean Connery. It's set on Alcatraz Island, a former prison in San Francisco Bay.

Could you please clarify the name of the film you are thinking of?