Re: SQL Server 2005 Windows Authentication - logon failure

Error: 18456, State 11 is "Login is valid, but server access failed."
1. In Management Studio, in Object Explorer, expand Security, expand Logins, right-click the users login, and then click Properties.
2. On the Status page, are Grand and Enabled selected?
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

<dooseiai@xxxxxxxxx> wrote in message news:f365be24-0f71-414f-97d4-f834c3f67c55@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi all,

I have a problem with SQL Server 2005. The application (written in
VB.NET) connects to SQL Server 2005 using Windows Authentication. When
a user's domain account had been locked out, the user - after it has
been made active again - cannot connect to the DB (with a message
"login failed for user (...)". The user's account is defined in the DB
it tries to connect to and it has necessary DB permissions. SQL
Server's log shows:

08/21/2008 09:11:39,Logon,Unknown,Login failed for user 'XXX\ABC'.
[CLIENT: XXX.XXX.XXX.XXX]
08/21/2008 09:11:39,Logon,Unknown,Error: 18456<c/> Severity: 14<c/>
State: 11.

Any ideas of what can be wrong?

Best regards,
Janusz

.

Relevant Pages

  • Re: SQL2005: Cannot connect error 11001
    ... The famous Windows Firewall (turned on my Server from which I'm trying to ... Exception Details: System.Data.SqlClient.SqlException: Login failed for user ... Try starting the SQL Server ... if you changed the port ...
    (microsoft.public.sqlserver.connect)
  • Re: error logging on SQL 2008
    ... I was, though, hoping for some more recognizable Reason for that error (state 11, " Token-based server access validation failed with an infrastructure error. ... Suggests that state 11 means "Valid login but server access failure", which doesn't really seem to rhyme with your description. ... How can you login to your SQL Server and use that tool if you can't log into your SQL Server? ... at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 Express setup
    ... Connect to your SQL Server Instance, ... Double click on the Login that you want to add to the "sysadmin" server role or right click on it and choose properties from the popup menu, ... Login is a member of the "sysadmin" fixed server role now. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2005 Express setup
    ... Connect to your SQL Server Instance, ... Double click on the Login that you want to add to the "sysadmin" server ... Mark the "sysadmin" checkbox to make this Login a member of this Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Clearer version of my earlier question re sp_grantlogin and sp_grantdbaccess
    ... > file while you do changes, so the script file in the end contains the ... >> Server, doesn't have the right to grant DB access to Domain Groups. ... > Tibor Karaszi, SQL Server MVP ... >> site where they let me login as Domain Admin. ...
    (microsoft.public.sqlserver.msde)