Pages

Thursday, November 28, 2013

The login packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library.[]

There can be many reasons for a Login Failure to SQL Server Instance.

Out of this you may get one as “The login packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library.[]”

This error may occur when The SQL Server computer was unable to process the client login packet. Inside the square braces, will be the IP of the client from which they are trying to login.

When the user is a member of many groups or has many policies, the token may grow larger than normal to list them all. If the token grows larger than the MaxTokenSize value of the server computer, the client fails to connect with a General Network Error (GNE) and error 17832 can occur. This problem may affect only some users: users with many groups or policies.

To Resolve this the MaxTokenSize value of the server computer needs to be increased.

To change the MaxTokenSize on the server computer, You need to have administrator rights on the server to perform this action.

  1. On the Start menu, click Run.

  2. Type regedit, and then click OK.

  3. Navigate to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Lsa\Kerberos\Parameters.

  4. Right-click MaxTokenSize, and then click Modify.

  5. In the Value data box type the desired MaxTokenSize value.

    1. Note: Hexadecimal value ffff (decimal value 65535) is the maximum recommended token size. Providing this value would probably solve the problem, but could have negative computer-wide effects with regard to performance. We recommend that you establish the minimum MaxTokenSize value that allows for the largest token of any user in your organization and enter that value.
  6. Click OK.

  7. Close Registry Editor.

  8. Restart the computer.

Changing registry value incorrectly may hamper the system. Please backup the registry and have this done by a System Administrator to be sure what is done.

No comments:

Post a Comment