The cloud: single sign-on killer or this year's security fad?

For many small to medium enterprises the answer to the question 'how do I manage passwords in the business?' has for the longest time been 'single sign-on.' However, single sign-on isn't a cheap option, nor are they traditionally easy to deploy across the enterprise. Could the cloud be about to hammer a few more nails into the single sign-on coffin?