Re: Howto troubleshoot login failure - State 11?
- From: "Jonny Bergdahl" <jonny.bergdahl@xxxxxxxxxxxxxxxx>
- Date: Tue, 27 May 2008 23:37:42 +0200
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
.
- Follow-Ups:
- Re: Howto troubleshoot login failure - State 11?
- From: "Charles Wang [MSFT]"
- Re: Howto troubleshoot login failure - State 11?
- References:
- Howto troubleshoot login failure - State 11?
- From: Jonny Bergdahl
- Re: Howto troubleshoot login failure - State 11?
- From: Chris Wood
- Re: Howto troubleshoot login failure - State 11?
- From: Russell Fields
- Howto troubleshoot login failure - State 11?
- Prev by Date: Re: Howto troubleshoot login failure - State 11?
- Next by Date: Re: cross database query with ownership chaining
- Previous by thread: Re: Howto troubleshoot login failure - State 11?
- Next by thread: Re: Howto troubleshoot login failure - State 11?
- Index(es):
Relevant Pages
|