Home Forums SQL Server 7,2000 Security Login failed for user with token-based server access validation error RE: Login failed for user with token-based server access validation error

  • eduardo.pin (7/14/2009)


    3) Run -- GRANT CONTROL SERVER TO "my login" for each user that you want to grant rights in the server.

    We have seen this issue when a Windows user was a member of too many Windows group as it causes the token to be too big (known issue... you can either reduce the groups or modify the registry on every system to increase the acceptable token size). But in any case, you probably want to resolve the root cause of this issue. Granting CONTROL SERVER is the equivalent of making everyone a member of the sysadmin fixed server role.

    K. Brian Kelley
    @kbriankelley