Post reply

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

  • July 28, 2018 at 5:03 pm

    #354788

    Hi All,

    I am facing below error in SQL connectivity while trying to connect using ODBC connection.

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

    User already have Connect SQL and connect permission and db_onwer access on the database. If I grant sysadmin then its working fine.

    can anyone help with the issue why SQL connection is failing with db_owner rights.



    -----------------
    Aditya Rathour
    SQL DBA

    Not Everything that is faced can be changed,
    but nothing can be changed until it is faced.

  • July 30, 2018 at 5:08 am

    #1999432

    I have found the root cause of the issue and want to share with you all. This error may occurred due to various reasons but in my case it was due to missing connect permission on TCP Endpoint.  After giving the Connect Permission on TCP endpoint connection is working fine for non-sysadmin users.

    -----------------
    Aditya Rathour
    SQL DBA

    Not Everything that is faced can be changed,
    but nothing can be changed until it is faced.

Viewing 2 posts - 1 through 1 (of 1 total)

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