Re: Howto troubleshoot login failure - State 11?

Are your SQL Server service account and the other service which tries to connect to your SQL Server instance, domain accounts or not?

--
Ekrem Önsoy



"Jonny Bergdahl" <jonny.bergdahl@xxxxxxxxxxxxxxxx> wrote in message news:F63550A0-CA30-4BBA-8355-9B9E27A79D6E@xxxxxxxxxxxxxxxx
select StartTime, TextData, NTUserName, HostName from ::

This is what the trace says.
2008-05-27 22:16:21.253 Login failed for user 'DOMAIN\BTS01$'. [CLIENT: 10.10.1.236] BTS01$ BTS01

Login failed for user 'Domain\User' [Client: xx.xx.xx.xx]
Error: 18456, Severity: 14, State: 11

Seems the info in the log is more detailed? What does State 11 indicate? I have not found anything relevant via Google.

The strange thing is that this login actually worked for a period of 20-30 minutes, and then suddenly stopped working again.

The setup is this:
The SQL server is installed on a domain controller.
The service accessing the SQL server is installed on a separate machine that is a member of the domain.
The service runs under the local Network service, which is why it uses the computer account to logon.
The computer account is member of a Windows group that is granted access to the server.

Please advice.

Regards;
/jb


.

Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Re: Does anyone know how to fix this??
    ... > Inside the Active Directory Users and Computers in the folder of SYSTEM I ... Give the site's SMS Service account full control rights to the ... MP encountered an error when connecting to SQL Server. ...
    (microsoft.public.sms.setup)