Monday, July 17, 2017

SQL Server error after update: The token supplied to the function is invalid

By Hường Hana 1:00 PM Leave a Comment

I was using my machine (and SSMS) and everything was working fine. I did a reboot whereupon Windows 10 applied the following updates:

Windows Malicious Software Removal Tool for Windows 8, 8.1, 10 and Windows Server 2012, 2012 R2, 2016 x64 Edition - April 2017 (KB890830) Security Update for Adobe Flash Player for Windows 10 Version 1607 (for x64-based Systems) (KB4018483) Security Update for Microsoft Silverlight (KB4017094) Cumulative Update for Windows 10 Version 1607 for x64-based Systems (KB4015217)

Now when I try to login in SSMS I'm getting the following error:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The token supplied to the function is invalid (Microsoft SQL Server)

The token supplied to the function is invalid

This looks like it is security related, but I don't know what to do to fix it. My machine uses Windows Server Essentials for backups (and the connector is green).

2 Answers

Answers 1

I had faced the same issue with SQL Server. I followed some steps and my problem was resolved. Those steps are as -

  1. Click Start, click Run, type regedit in the Open box, and then click OK.

  2. Locate and then click the following subkey in the registry: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\SecurityProviders\SCHANNEL

  3. On the Edit menu, point to New, and then click DWORD Value.

  4. Type SendExtraRecord for the name of the DWORD value, and then press Enter.
  5. Right-click SendExtraRecord, and then click Modify.
  6. In the Value data box, type 2 to disable the split record in schannel, and then click OK.
  7. Exit Registry Editor.

Answers 2

Execute in command line with administrative privilege and reboot.

netsh winsock reset
If You Enjoyed This, Take 5 Seconds To Share It

0 comments:

Post a Comment