New
#1
Win7 VPN & SQL server: Cannot generate SSPI context
After alot of searching i found a good solution to the problem when using Windows login to a SQL server while on Win VPN giving the error: Cannot generate SSPI context.
Wanted to share it:
- 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)- Open the file in Notepad using Open with...
- Locate the following entry: UseRasCredentials=1
Each VPN connection you have has a section marked with [<VPN connection name>]- Modify the entry to the following: UseRasCredentials=0
Needs to be done for each VPN section for the connections having problems.- On the File menu, click Save, and the click Exit.