Howto troubleshoot login failure - State 11?
I have a problem where a logon account is denied access to SQL Server 2005.
The server log:
Login failed for user 'Domain\User' [Client: xx.xx.xx.xx]
Error: 18456, Severity: 14, State: 11
How do I troubleshoot this? The account is a member of a Windows group, and
it is the group that is granted access to the SQL server.
Regards;
/jb
.
Relevant Pages
- Re: Managing SQL database rights using AD
... logins to SQL Server. ... You would add these two logins you ... just added as users in the database. ... the Windows group that you just added as logins (and then ...
(microsoft.public.sqlserver.security) - Re: Service Agent Not starting
... After changing the logon account to local system the problem was resolved. ... Also look in the SQL Server error ... > Devapriya De Silva wrote: ...
(microsoft.public.sqlserver.tools) - Re: Access Project Deployment
... If you and your clients are in a trusted domain environment, how about using Windows Authentication method to authorize your users? ... Create a Windows Group and make your clients member of that group and then go to SQL Server. ... Create a login for that Windows Group and give them necessary rights and permissions so that they will be able to connect to the mentioned database. ...
(microsoft.public.sqlserver.clients) - RE: How to get permission to backup DB to My Documents folder
... I'm using VB 2005 with SQL Server 2005. ... Dim backupSQL As New SqlCommand("BACKUP DATABASE TO ... Was your Windows logon account a local administrator? ...
(microsoft.public.sqlserver.replication) - Re: domain groups not visible
... be sure your SQL Server server is a part of the Domain. ... And when you click New Login and then Search to find the group that you create on AD check out the Object Types from the "Select User or Group" window to be sure that Groups are included in your search. ... Then create a login in SQL Server for that Windows Group. ...
(microsoft.public.sqlserver.security) |
|
