Re: Howto troubleshoot login failure - State 11?



It could be that the default database the login uses is no longer defined or

The event log also shows a Failure audit event for each failed logon. The Data part of the event displays the strings 'SQL01' and 'master', so it is not trying to access anything out of the ordinary.

The Windows group used is the 'BizTalk Server Administrators' group that is setup by the BizTalk installation program. Normal users in this group has no problems accessing the server.

Also - I added the computer account as a user on the server (CRETE LOGON [DOMAIN\BTS01] FROM WINDOWS). As it only had the public role, it failed to logon, but this time with State 16. The error message reported that it could not open the requested database. This indicates to me that it is not a database access issue, but a problem accessing the server itself. Granting the account the sysadmin role gives access to the server, but this is no solution to my problem. I need the computer account to login through a Windows user group in order to access BizTalk properly.

The error "State 11 - Login is valid, but server access failed" leaves me with very few clues as how to continue tracking this problem down.

Any further assistance is much appreciated.

Btw; I have another computer using a computer account to logon to the SQL server, this computer is member of another group, and it works without any problems.

Regards;
/jb

.



Relevant Pages

  • Re: MS03-039 (824146) causes logon problem
    ... The computer account is there. ... Unfortunately I can not logon to the domain ... >> Domain controller is Windwos 2000 server. ... >> problem of logon to the Windows 2000 AD server ...
    (microsoft.public.win2000.security)
  • Re: Computer Connect Wizard
    ... Logon to the server and open the Management console ... Check if the name of the workstation is already there. ... Locate the computer account there, ... Logon to the workstation. ...
    (microsoft.public.windows.server.sbs)
  • XP takes forever to logon to Network (w2k)
    ... I assume you are logging onto a w2000 server. ... problem but once i recreated the computer account on the ... the security cert will be different. ... >machines can logon is less than a minute. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Please help refresh my memory on AD DC
    ... When I boot my Laptop I reach the Logon screeen for XP Laptop and here ... admin account to be able to Login so I can control it from the DC. ... A domain user can by default logon to any domain computer, except Domain controllers. ... A Server has websites already hosted on it in a Workgroup and now I ...
    (microsoft.public.windows.server.active_directory)
  • Re: Logon Server Unavailable
    ... There are currently no logon servers available to service ... You use a office laptop to connect the office VPN, when you map a network ... you may receive this message: "This account is the ... The server is not configured for transactions"> "A domain controller for your domain could not be contacted" ...
    (microsoft.public.windows.server.dns)