2 Windows Server 2012 VM's on MS Azure and access is via RDP over Azure Point to Site VPN using a client certificate.
I can connect to the VM's fine but I need to connect to SQL Server 2008 R2 which is running on the VM. Connecting now gives me a "cannot generate SSPI context" which I assume is down to my current windows logon not been part of the domain.
I am not able to change the VPN setup to use Username / Password as it always reverts back to certificate.
How can I connect to my instance of SQL ? Can I somehow add the client cert to the sql login ?
Any help would be great.