BUG: "Login time-out" Property Value Does Not Take Effect For SQL Query Analyzer (812282)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)

SYMPTOMS

When a log on process takes more than 15 seconds, Microsoft SQL Query Analyzer times out, without considering the LoginTimeout property value.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

You use the LoginTimeout property to specify the time to wait (in seconds) for a connection before the operation times out.

How to Set LoginTimeout for SQL Query Analyzer


To set the LoginTimeout value for SQL Query Analyzer, use these steps:
  1. Open Query Analyzer.
  2. On the Tools menu, click Options.
  3. In the Options dialog box, click Connections .
  4. Type the value for LoginTimeout in the Login time-out (seconds) text box.
  5. Click OK

How to Set LoginTimeout for SQL Enterprise Manager


To set the LoginTimeout value for SQL Enterprise Manager, use these steps:
  1. Open Enterprise Manager.
  2. On the Tools menu, click Options.
  3. In the Options dialog box, click Advanced .
  4. Type the value for LoginTimeout in the Login time-out (seconds) text box.
  5. Click OK.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbnofix kbBug KB812282 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.