[RESOLVED] Cannot connect to SQL Server whilst using VPN under Windows 7

[Teknophobia]

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

[jdc2000]

Possibly useful links, if you haven't already seen them:

http://social.msdn.microsoft.com/For...7-f129de870714

http://social.answers.microsoft.com/...3-b6a25d5bd631

http://www.google.com/search?hl=en&s...=&oq=&gs_rfai=

[Teknophobia]

Only just revisiting this now, sorry for delay in response.

Solution to my issue was here: http://www.sevenforums.com/network-s...ml#post1178681

1. Locate the .pbk file that contains the entry that you dial. Is either: C:\Users\<USERNAME>\AppData\Roaming\Microsoft\Network\Connections\Pbk or if connection is visible to all users: C:\ProgramData\Microsoft\Network\Connections\Pbk
(hidden files may need to be disabled first through Organize -> Folder and search options)

2. Open the file in Notepad using Open with...

3. Locate the following entry: UseRasCredentials=1
Each VPN connection you have has a section marked with [<VPN connection name>]

4. Modify the entry to the following: UseRasCredentials=0
Needs to be done for each VPN section for the connections having problems.

5. On the File menu, click Save, and the click Exit.

[jdc2000]

Thanks for the update on the solution.