Re: Howto troubleshoot login failure - State 11?

Hi Jason,
From your description, I understand that the real problem here was that
your computer account could access your SQL Server instance, however the
connection accidentally failed after 20-30 minutes. It belongs to a Windows
group which is granted access to your SQL Server.
If I have misunderstood, please let me know.

I think that this issue might happen when the computer account tried to
access some database on which it had no access permission. However for
further research, I would like to collect more information from you:
1. What are the database access permissions assigned to your Windows group
in your SQL Server?
2. What is the result if you explicitly assign the fixed server role
sysadmin to your Windows group?
3. Could you please mail me (changliw_at_microsoft_dot_com) your SQL error
logs which are located in the folder %ProgramFiles%\Microsoft SQL
Server\MSSQL(.x)\MSSQL\LOG?

Look forward to your response. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

.

Relevant Pages

  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ... SQL Server Database Services 2005 ENU SP2 ...
    (microsoft.public.windowsupdate)
  • RE: cannot delete a record in sql server 2005 through asp program
    ... Using trace script he provided and trace file created by the script. ... SQL Server database by the asp application. ... Microsoft Online Community Support ... a Microsoft Support Engineer within 2 business day is acceptable. ...
    (microsoft.public.sqlserver.programming)
  • Re: enumerating Sql Servers is wrong on some systems
    ... How do we get the correct enumeration? ... I know that you install a SQL Server named ... Microsoft Online Community Support ... a Microsoft Support Engineer within 2 business day is acceptable. ...
    (microsoft.public.sqlserver.setup)
  • Re: multithreaded tcp/ip server large page file
    ... Part of the processing being done by each thread is contacting a sql server and if the sql server is having problems processing by this program backs up and I've seen it with over 100 threads open before. ... It handles it fine as the sql request time out this program returns and error response to the TCP/IP client that the thread is handling and the sub/tread ends. ... The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: multithreaded tcp/ip server large page file
    ... Part of the processing being done by each thread is contacting a sql server and if the sql server is having problems processing by this program backs up and I've seen it with over 100 threads open before. ... It handles it fine as the sql request time out this program returns and error response to the TCP/IP client that the thread is handling and the sub/tread ends. ... The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.dotnet.languages.vb)