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

  • I Have this issue running SQL Server 2008 and this message was in the log:

    "Login failed for user '%'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors"

    I could not use any other login except by the login that was used to install SQL Server. So the solution was:

    1) Login in the server with the same account used to setup SQL Sever.

    2) Open management studio

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

    This worked for me.

    Bye

    Eduardo Pin