I get a "cannot generate sspi context" when trying to connect to a SQL 2008R2 instance.
There are not duplicate SPN records on the network, I've checked this.
We are getting this error on the SQLservice account:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
to the user Domainname\SQL_service SID (S-1-5-21-1728536662-146330824-3268609631-1851) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.
But this is pretty much all I can see from an Event Log POV
I can log-in locally used my UN adn PW as authentication but not remotely from my PC.