Under Windows XP, I can connect to one of our external client sites using VPN (PPTP) and then locally use our internet, email, local network access and crucially, our helpdesk system which resides on a SQL Server 2005 database.

Having installed a new PC with Windows 7 (Pro 64-bit), connection to our helpdesk software is no longer possible when connected to remote client site via VPN. I get SQL error 'Cannot generate SSPI context'. Access to internet, email and local network (including server where SQL Server is located) is fine.

Interestingly enough, I have a virtual machine running XP on this PC, and the VM can VPN to client and access the SQL Server database at the same time, so it appears to be confined to Windows 7.

I have tried 1 hundred different things, but cannot isolate the issue (have gone through and changed pretty much everything in the VPN connection setup including Networking and VPN security settings, including changing the metric to a higher number, enabling/disabling 'use default gateway on remote network' which incidentally is checked on XP set-up). Also turned on a few of the Windows 7 features, updated the drivers for the NIC, added SQL server ODBC connections using the 32bit and 64bit ODBC adminstrator, all to no avail.

Just wondering if there is an obvious solution that I have not thought of? Perhaps a new feature or security restriction in Windows 7?

Cheers,

TEk