Solution - Login failed for user x. Reason Token based server access validation failed and error - 18456

Posted by simonsabin on SQL Blogcasts See other posts from SQL Blogcasts or by simonsabin
Published on Tue, 01 Feb 2011 09:28:34 GMT Indexed on 2011/02/01 15:29 UTC
Read the original article Hit count: 410

Filed under:

Tips and Tricks

|

security

Had a very bizarre situation yesterday where a local machine account couldn’t access SQL Server and was getting Login failed for user <user>. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <client ip>] along with Error: 18456, Severity: 14, State: 11. The user was in the logins even after a refresh, it was in the users for the database. I decided to delete and remove the login and heh presto it worked. I thought you...(read more)

© SQL Blogcasts or respective owner

Related posts about Tips and Tricks

3 Tips of SEO That Will Make You Money - Search Engine Optimization Tips

as seen on Ezine Articles - Search for 'Ezine Articles'
You need to make sure your marketing methods rank high in the Google and Yahoo search engines; to do this you're going to need to understand search engine optimization. Here are 3 SEO tips. >>> More
More Linux Tips and Tricks

as seen on Internet.com - Search for 'Internet.com'
we learn how easy it is to configure OpenSSH to use secure public key authentication instead of a password login. >>> More
More Table View Tricks for the iPhone

as seen on Internet.com - Search for 'Internet.com'
Go beyond the basics of the iPhone Table View with examples for grouping rows into sections, displaying an index on the side, and adding a Search Bar. >>> More
More Table View Tricks for the iPhone

as seen on Internet.com - Search for 'Internet.com'
Go beyond the basics of the iPhone Table View with examples for grouping rows into sections, displaying an index on the side, and adding a Search Bar. >>> More
SQL SERVER – Fix : Error 3623 – An invalid floating point operation occurred

as seen on SQL Authority - Search for 'SQL Authority'
Going back in time, I always had a problem with mathematics. It was a great subject and I loved it a lot but I only mastered it after practices a lot. I learned that mathematics problems should be addressed systematically and being verbose is not a trick, I learned to solve any problem. Recently one… >>> More

Related posts about security

sudo apt-get update errors

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Here is what I get on my terminal when running sudo apt-get update errors. I dont know if the issue is from my sources.list or my proxy setup(have not made any changes to proxies). Thank you for any help in advanced. Ign http://security.ubuntu.com oneiric-security Release.gpg Ign http://security… >>> More
The Security-Developer Gap: Why IT Security Can't Fix Your Security Problems Alone

as seen on Devx - Search for 'Devx'
Two well-known white hats explain how hackers take advantage of security holes left by enterprise application developers. >>> More
The Security-Developer Gap: Why IT Security Can't Fix Your Security Problems Alone

as seen on Internet.com - Search for 'Internet.com'
Two well-known white hats explain how hackers take advantage of security holes left by enterprise application developers. >>> More
StackOverFlowError while creating Mac object on AS400/Java

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all, I am a newbie to AS400-Java programming. I am trying to create my first program to test the implementation of Message Authentication Code (MAC). I am trying to use the HMACSHA1 hash function. My (Java 1.4) program runs fine on a dev box (V5R4).But fails terribly on the QA box (V5R3). My… >>> More
Google App Engine - Spring Security Issue (java.security.AccessControlException)

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently getting the AccessControlException below when I deploy to app engine (I don't see it when I run in my local environment). I'm using GAE 1.3.1, Spring 3.0.1, and Spring Security 3.0.2. Any ideas how to get around this issue? It appears to be an issue with Spring Security trying to get… >>> More