SQL Server 2005 Windows Authentication - logon failure

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: Linked Server Connection Problem
    ... Use SQL authentication to connect to the SQL server from the client, ... set the domain account used to start SQL Server to have permissions in the ... Establish a SPN for your domain account which will enable Kerberos ... Load the Active Directory Users and Computers MMC snap-in. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Services account question...
    ... I wish you'd say the reason of not using a domain account as a service account for the SQL Server. ... Backup operations are performed by SQL Server service, at this point I don't know what goes on under hood exactly but SQL Server service may be needed to communicate to the AD for validation of the database owner and as the SQL Server service is a local one, it can't achieve this task. ... > Source: Security Event ID: 537 ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for user NT AUTHORITYANONYMOUS LOGON
    ... >>I've enabled anonymous access, setting it to the correct domain account, ... >> the correct permissions in sql server ... > That means the local user permissions, the SQL Server, etc. ... >> c) I've enabled anonymous access, setting it to the correct domain account, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Problems changing the password for the service account in SQL
    ... Adding the domain account which runs SQL Server into SQL Server doesn't ... Server if it is running under the domain account. ... Admin-SQL, Logon Exec - exception from ...
    (microsoft.public.sqlserver.security)
  • Re: FAILURE installing WSS with Active Directory auth
    ... SQL Server should also be running under a Domain Account. ... Did you add IIS after the server was promoted to a DC? ... > - local admin as well as admins in AD. ...
    (microsoft.public.sharepoint.windowsservices)