No, a cover letter is not needed but as AbrahamT mentions, you won't be able to efile your return. Since you do need to mail in return, you might include a cover letter stating you tried to obtain the SSN but were unable to but this isn't mandatory.
@Happymonkey1234