September 9, 2015 at 8:06 am
Hi, any idea on the below error..
Login failed for user 'IHS\test_user'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 102.21.48.258]
the login looks fine form SQL side as I tried to log in and run few queries.
Any help is appreciated
September 9, 2015 at 8:14 am
Aatish Patel (9/9/2015)
Hi, any idea on the below error..Login failed for user 'IHS\test_user'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 102.21.48.258]
the login looks fine form SQL side as I tried to log in and run few queries.
Any help is appreciated
If you try searching for that exact error message you will find thousands and thousands of post about this error. There is likely a deny connect permission for that user.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 9, 2015 at 8:40 am
Aatish Patel (9/9/2015)
Hi, any idea on the below error..Login failed for user 'IHS\test_user'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 102.21.48.258]
the login looks fine form SQL side as I tried to log in and run few queries.
Any help is appreciated
There should be some additional information in the line after the Login Failer in the SQL Server Log. It should look like Error: 18456, Severity: 14, State: 11. for example.
You can use this message and this blog post from Aaron Bertrand to get a better idea of what is happening. http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx
September 9, 2015 at 9:27 am
thanks all. have tried all and still looking around to resolve this. If any more info please let me know
September 9, 2015 at 9:39 am
Hi,
thanks for looking into this. so by: There is likely a deny connect permission for that user.... do you mean need to look into active directory for this login and see what permissions does this user have?
September 9, 2015 at 9:52 am
Aatish Patel (9/9/2015)
Hi,thanks for looking into this. so by: There is likely a deny connect permission for that user.... do you mean need to look into active directory for this login and see what permissions does this user have?
NO. Look at the user in sql server.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 9, 2015 at 9:55 am
Aatish Patel (9/9/2015)
thanks all. have tried all and still looking around to resolve this. If any more info please let me know
We can't provide you any more info. We both suggested a couple of places to look at to solve this issue. We can't do it for you because we haven't been provided a lot of information and quick frankly it requires you looking at the settings of things on your end which we can't do from here. Did you read the article posted? It has your exact error in there and explains how to fix it. As I suggested previously any search engine will have thousands of articles explaining the same thing.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply