EF 4.1 exception “The provider did not return a ProviderManifestToken string”

I was getting this error and tried a few of the earlier suggestions. Then I checked the Inner Exception and noticed I was getting a simple SQL login failure for the user. Just something else to check.