Post reply

Error during Login Process (to SQL Server 2005)

  • November 8, 2011 at 8:49 am

    #1404623

    How many groups is the windows account a member of. I have had this issue when passing Active Directory accounts with a lot of group memberships. The Kerberos tokensize is not big enought to store the kerberos credintials and it fails out. Try to add a MaxTokenSize to the follow key in registry. \HKEY_LOCAL_MACHINE\SYSTEM\CURRENTCONTROLSET\LSA\Kerberos\Parameters. Add a 32bit regDword called MaxTokenSize and modify to decimal 65535 (this is the max setting for this) You may want to set as low as you can if this works.

    Might as have to add to any other controlset in system

    Reboot.

  • November 25, 2011 at 8:09 am

    #1412996

    (removed - posted in error)

  • November 25, 2011 at 8:10 am

    #1412997

    (removed - posted in error)

  • May 25, 2017 at 4:20 am

    #1944130

    Sometimes this error comes due to overload of connections on SQL Server. So just change your DB to Single User and again change it to Multi user.

    Or simply execute this query.

    use master
    ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
    ALTER DATABASE DatabaseName SET MULTI_USER

    That solved my issue. 🙂
    Enjoy..!!

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply